Quickly add horizontal or vertical average line to a chart in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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 Tools > Add Line to Chart, see screenshot:
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:
3. Then, click Ok button, a horizontal average line will be inserted into the column chart at once, see screenshot:
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:
And a vertical specific value line will be added into the bar chart, see screenshot:
2. You can change the color or type of the line to your need as following screenshot shown:
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
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

