Add a trend or moving average line to a chart in Office 2010 Add a trendline (Office 2010) On an unstacked, 2-D, area, bar, column, line, stock, xy (scatter), or bubble chart, click the data series to which you want to add a trendline or moving average, or do the following to select the data series from a list of chart elements.
![](/uploads/1/2/6/7/126747055/307013555.jpg)
Chart in Excel are always used to analyze some important information. Therefore, in this article we will demonstrate how to add horizontal average line to vertical chart in Excel.In an Excel worksheet, you will always add a chart according to the data in certain cells. And sometimes, you will need to know the average level of certain index. For example, in this image, you can see that there is a bar chart for the sales volume of those sales representatives.However, the average level is hard to see from this chart. Thus, you need to add an average line into this chart.
And the following are the two ways to add. Add Horizontal Average Line to Vertical ChartThe following are the steps to add a horizontal average line. In the original worksheet, add a column of average sales volume.And you can use the Average function to calculate the number. Select the whole area including the average column. Click the “Insert” tab in the ribbon. And then click the “Column”. Now in the drop down menu, click the clustered column to create a bar chart.
Thus, you have created a new chart. Right click any of the red bars in the column. In the new menu, choose the “Change Series Chart Type”. And then in the “Change Chart Type”, choose the line chart. Next click “OK”. Therefore, you have finished all the setting, and you can see that in the bar chart, there is an average line.Add Horizontal Line through Inserting Line FeatureThis is the other method to add an average line.
In the original worksheet, add a row of average sales volume. Select the whole area. Repeat the step3-step5 in the previous part to create a bar chart. Click the chart to position the cursor on the chart. If you skip this step, the line will not in the chart. Click the “Insert” tab in the ribbon. And then click the “Shapes”.
In the drop-down menu, choose the “Line”. Then hold the key “Shift” on the keyboard. In this step, you should be more careful. Put your cursor on the top of the bar “Average”. Then use your mouse to drag and draw a line in the chart.
![How do i add a target line to a bar graph in excel? How do i add a target line to a bar graph in excel?](/uploads/1/2/6/7/126747055/264253166.png)
Because now you are holding the “Shift”, you don’t need to worry about the line will not be horizontal.Thus, the average line will be created. And if you want to change the color or the type to make it clearer, you can also set in the ribbon.The above are the two ways to add horizontal line into a vertical chart.
In addition, in the next article, we will introduce about adding a vertical line into the horizontal bar chart. Author Introduction:Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including and outlook repair software products. For more information visit.
This post will teach you how to add a horizontal benchmark line to an existing or graph in excel. How do I add a horizontal baseline or target line to a chart or graph gives loads of context for the viewer.For example, you have a simple Excel spreadsheet tracking product sales. And you have a column with dates and another with sales. And you have made a simple chart with both columns as data sources. And you want to add a horizontal baseline to this chart so that the user can see how close they are to their target sales. You can follow this guide to achieve the result. Adding a horizontal Benchmark/Baseline/Target Line to a Chart or GraphTo add a horizontal benchmark line to a chart, just do the following steps:#1 create a new benchmark line column that contains benchmark sales data.#2 Right-click on the existing chart, and choose Select Data from the drop-down menu list.#3 the Select Data source window will appear.#4 click Add button under Legend Entries section, the Edit Series window will appear.#5 enter one Series name such as: Benchmark line into the Series name text box.
![Free Free](https://www.myexcelonline.com/blog/wp-content/uploads/2015/12/line-with-markers.png?x85520)
Then select benchmark line column as its series values. Then click OK button.
![](/uploads/1/2/6/7/126747055/307013555.jpg)