Forum Discussion
DRTE
Jul 28, 2026Occasional Reader
How to add an "Average" line in a simple line chart
I have a simple line chart showing monthly data for one year. I want to show the annual average as a straight line from Jan through Dec. How do I do That?
PeterBartholomew1
Jul 29, 2026Silver Contributor
Vertical or horizontal lines can also be added as error bars emanating from any single point. In this case, the average could be plotted at the left of the plot and a fixed value of the chart width chosen for the positive horizontal error bar. I tend to match the colour to the data series but show averages, maxima and minima as some form of dashed line.