Unique Excel Chart Average Line

In order to add a horizontal line in an Excel chart we follow these steps.

Excel chart average line. Unfortunately there is no one-click command that adds an average line to the graph so we will have to take some additional steps. Ad Turn Static Charts into Interactive Data. We want to add a line that represents the target rating of 80 over the bar graph.

A common task is to add a horizontal line to an Excel chart. Right-click it and choose Change Series Chart Type in the context menu. Change the chart type of average from Column Chart to Line Chart With Marker.

Seems easy enough but often the result is less than ideal. Insert a column before the Amount column with right clicking the Amount column in the source data and selecting Insert from right-clicking menu. Home The news about Excel Add average line to Excel chart.

Now to add an average line or grand total line in a pivot chart in Excel you can do as follows. For this select the average column bar and Go to Design Type Change Chart Type. Use a line chart if you have text labels dates or a few numeric labels on the horizontal axis.

In the Change Chart Type dialog box make sure Combo Custom Combination template is selected which should be by default. Next step is to change that average bars into a horizontal line. The Easiest Way How to Add an Average line in an Excel Graph The easiest way to include the average value as a line into the chart is to click anywhere near the chart.

In this quick tutorial well walk through how to add an Average Value line to a vertical bar chart by adding an aggregate statistic Average to a data set and changing a series chart type. On the Format tab in the Current Selection group select the trendline option in the dropdown list. Learn a simple way to add a line representing the average value on a line chart this also works for other types of chart.