Forum Discussion
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?
There are number of options. one option is just add a column/row next to the data that for all months = average of the months and then add that column/row to the graph. you can add the data either on the graph change the data range or insert additional data or you can copy the data range on the sheet and then on the graph use paste special.
Just note, although not the average line you could also consider adding a trendline for the data series.