Quickly add horizontal or vertical average line to a chart in Excel

When you create a column or bar chart in Excel worksheet, sometimes, you may want to add an average or a target line for comparing with the column or bar values. Normally, with the built-in feature in Excel, you need to insert an average bar or column data, and then change the bar to line type, but, in this article, you will get a powerful feature-Add Line to Chart of Kutools for Excel, with the help of this utility, you can add a horizontal or vertical average or specific value line to the column or bar chart with ease.

Quickly add horizontal or vertical average or specific value line to chart in Excel


Quickly add horizontal or vertical average or specific value line to chart in Excel

Please do with the following steps for adding the average or specific value line to a chart:

1. First, create a column or bar chart based your data, then click to select the created chart, and then, click Kutools > Chart > Chart ToolsAdd Line to Chart, see screenshot:

shot add line to chart01

2. In the Add line to chart dialog box, select Average or Other values you need from the Where to insert section, in this example, I will select Average option, see screenshot:

shot add line to chart01

3. Then, click Ok button, a horizontal average line will be inserted into the column chart at once, see screenshot:

shot add line to chart01

Notes:

1. If you have a bar chart, after selecting the Average or specifying a certain value in the Other value textbox as following screenshot shown:

shot add line to chart01

And a vertical specific value line will be added into the bar chart, see screenshot:

shot add line to chart01

2. You can change the color or type of the line to your need as following screenshot shown:

shot add line to chart01

3. This line is static, it will not change when the original data changes, so, if your original data changes, you should apply this feature again to get the correct result.


Add horizontal or vertical average line to a chart

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.