Fine Beautiful Excel Graph Add Average Line

Right-click anywhere on the existing chart and click Select Data.

Excel graph add average line. Click the column chart to activate the Chart Tools and then click Design Add Chart Element Trendline Moving Average. Id like to add a solid horizontal line to the graph indicating the average of the data values on the Y axis. For example you have created a column chart in Excel as below screenshot shown.

Now to add an average line or grand total line in a pivot chart in Excel you can do as follows. Get x and y values for a specific data point in a scatter chart. Insert a column before the Amount column with right clicking the Amount column in the source data and selecting Insert from right-clicking menu.

2 then the Visual Basic Editor window will appear. Right-click any of the columns in the Average series on the chart In the quick menu click Change Series Chart Type In the Change Chart Type dialog choose a basic Line chart. Select range A1C7.

And the Select Data Source dialog box will open. Add average line to Excel chart. 3 click Insert - Module to create a new module.

Full Feature Free Trial 30-day. If youd like to draw a line at some existing data point extract its x and y values as explained in this tip. 1 click on Visual Basic command under DEVELOPER Tab.

Adding a series data. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows. Unfortunately there is no one-click command that adds an average line to the graph so we will have to take some additional steps.