Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

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

Author Xiaoyang Last modified

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 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 chart02

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

shot add line to chart03

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 chart04

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

shot add line to chart05

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

shot add line to chart06

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: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

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.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon