Chart with average line

In Microsoft Excel, you can add an average line to a chart to show the average value for the data in your chart. In this Excel, tutorial you will learn how to create a chart with an average line.

First, prepare some data tables.

data table average line

Preparing an average line for a graph

Click on the average column. Use Excel average function for calculations. Type in =AVERAGE(all cells in the total column ex. $B$2:$B$24) and click enter.

Average column

In my example formula is =AVERAGE([Sales]) or =AVERAGE($B$2:$B$24). On, you can learn more about Define Name.

Select all the data, and create the chart by clicking on insert tab. I recommend Column Chart or Line Chart.

Column chart with Average Line

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

Change Series Chart Type

Inserting average chart

Choose a Line Chart.

Line Chart

Adding an average line in chart

The average line chart 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 choose another type of line, and write the title of chart.

See also  How to Make a Bullet Chart in Excel