Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 30, 2023

This graph will demonstrate how to add an average line to a graph in Excel.

## Add Average Line to Graph in Excel

We’ll start with the below bar graph. The goal of this tutorial is to add an average line to help show how each bar compares to the average.

In the next column, create an average formula by typing in =AVERAGE(Range), in this case =AVERAGE(\$C\$6:\$C:\$10). The average should be the same number for each X Axis. (Note: use \$s to lock the cell references so they don’t change when the formula is copied down).

### Adding Average Dataset to Graph

1. Right click graph
2. Click Select data

4. Select Header under Series Name

5. Select Range of Values for Series Values and click OK.

Change Average to Line Graph

1. Right click on graph
2. Select Change Chart Graph

3. Select Combo

4. Click Graph next to Average

5. Select Line

### Final Graph with Average Line

As you can see, the final product is a bar graph of the items with an average line to show comparisons between the items.

1. Select Data that was put together in Excel
2. Click Insert
3. Click Chart