Simple Inserting Average Line In Excel Chart

Id like to add a solid horizontal line to the graph indicating the average of the data values on the Y axis.

Inserting average line in excel chart. Thats how you add a line in Excel graph. Copy the averagebenchmarktarget value in the new rows and leave the cells in the first two columns empty as shown in the screenshot below. Now the horizontal average line is added to the selected column chart at once.

Add the AutoFilter icon to the Quick Access Toolbar. Seems easy enough but often the result is less than ideal. Select the column chart and click Kutools Charts Add Line to Chart to enable this feature.

So now you have a column chart in your worksheet like below. In order to add a horizontal line in an Excel chart we follow these steps. In the Add line to chart dialog please check the Average option and click the Ok button.

Add a moving average line You can format your trendline to a moving average line. Click and drag the bottom right corner of the selection to expand it to the Average column. You can add a moving average line in the column chart easily as follows.

A common task is to add a horizontal line to an Excel chart. We want to add a line that represents the target rating of 80 over the bar graph. In the Change Chart Type dialog window do one of the following depending on your Excel version.

The horizontal line may reference some target value or limit and adding the horizontal line makes it easy to see where values are above and below this reference value. From the Design tab choosethe Chart Style. The range of data already displayed in the chart has been highlighted in the table.