Chart with average line in Excel

In this Excel tutorial you will teach yourself how to create a chart with average line. First prepare some data table average lineCreate another column. Calculate an average here.Average columnIn my example formula is =AVERAGE([Sales]) or =AVERAGE($B$2:$B$24). On you can learn more about Define Name and Average function.Next create a chart. I recommend Column Chart or Line Chart.

Column chart with Average Line

Right click the average column. From the list choose the Change Series Chart Type option.

Change Series Chart Type

Choose Line Chart.

Line Chart

Average Line is ready.

Chart with Average Line

This is it. Average line on the chart could be useful to compare data with an average value.


You can download the Template here – Download