Chart with average line

In this Excel tutorial you will teach yourself how to create a chart with average line.

First prepare some data table.

data table average line

Create another column. Calculate an average here.

Average column

In my example formula is =AVERAGE([Sales]) or =AVERAGE($B$2:$B$24). On best-excel-tutorial.com 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.