Now to add an average line or grand total line in a pivot chart in Excel you can do as follows. The popup window will show you the chart type for each data series. There is no tool in Excel to do t. You can title this Average or something relevant to your needs. Select the Trendline option. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows. You should now have a column that has the same value for every cell. On the Format tab in the Current Selection group select the trendline. Excel has two functions average and stdev respectively that calculate these two values from raw data that you would enter into a spreadsheet. By default however Excels graphs show all data using the same type of bar or line.

Select the column chart and click Kutools Charts Add Line to Chart to enable this feature. Click anywhere in the chart. You can customize the type of trend line that you want by clicking the right-facing arrow and choosing from the options provided linear exponential linear forecast moving average etc The most commonly used trend lines are just the basic linear trend line and the moving average trend line. On the Format tab in the Current Selection group select the trendline. By default however Excels graphs show all data using the same type of bar or line. Add a moving average line You can format your trendline to a moving average line. Add moving average line in an Excel chart For example you have created a column chart in Excel as below screenshot shown. Calculate the average by using the AVERAGE function. In 2016 versions hover your cursor over the options to display a sample image of the graph. 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.

You can customize the type of trend line that you want by clicking the right-facing arrow and choosing from the options provided linear exponential linear forecast moving average etc The most commonly used trend lines are just the basic linear trend line and the moving average trend line. You can add a moving average line in the column chart easily as follows. Since you want the average to show up as a line instead of columns right click on the data series and select Change Series Chart Type. Learn a simple way to add a line representing the average value on a line chart this also works for other types of chart. Add a moving average line You can format your trendline to a moving average line. You should now have a column that has the same value for every cell. Updating the Data Set. Calculate the average by using the AVERAGE function. Change the Chart Type for the Average series to a Line chart. How to draw an average line in Excel graph This quick example will teach you how to add an average line to a column graph.

Add a column to your spreadsheet where the chart data resides. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows. You will have calculated this average beforehand using AVERAGE or SUM data range number of rows. In this column for every row enter the average. You can customize the type of trend line that you want by clicking the right-facing arrow and choosing from the options provided linear exponential linear forecast moving average etc The most commonly used trend lines are just the basic linear trend line and the moving average trend line. The range of data already displayed in the chart has been highlighted in the table. Add a moving average line You can format your trendline to a moving average line. Excel creates the line graph and displays it in your worksheet. How to draw an average line in Excel graph This quick example will teach you how to add an average line to a column graph. In 2016 versions hover your cursor over the options to display a sample image of the graph.

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. The range of data already displayed in the chart has been highlighted in the table. Select one Average column the green bricks and right click to select Change Series Chart Typ. Excel has two functions average and stdev respectively that calculate these two values from raw data that you would enter into a spreadsheet. Click anywhere in the chart. The popup window will show you the chart type for each data series. Select the data range and click Insert Column Clustered Column see screenshot. You can further make formatting adjustments according to your preference. On the Format tab in the Current Selection group select the trendline. Other Versions of Excel.