Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Kutools for Excel 22.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 14.00HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 13.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  9.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

How to add horizontal benchmark/target/base line in an Excel chart?

Let's say you have created a column chart to show four teams' sales amount in Excel. But now, you want to add a horizontal benchmark line in the chart, how could you handle it? This article will introduce three solutions for you!


Add horizontal benchmark/base/target line by adding a new data series in an Excel chart

This method will take the benchmark line for example to guide you to add a benchmark line, baseline, or target line in an existing chart in Excel.

1. Beside the source data, add a Benchmark line column, and fill with your benchmark values. See screenshot:

2. Right-click the existing chart, and click Select Data from the context menu. See screenshot:

3. In the Select Data Source dialog box, please click the Add button in the Legend Entries (Series) section. See screenshot:

4. In the popping Edit Series dialog box, please (1) type Benchmark line in the Series name box, (2) specify the Benchmark line column excluding the column header as Series value, and (3) click the OK buttons successively to close both dialog boxes. See screenshot:

Kutools for Excel

Stand out from the Crowd

300 Handy Tools
Solve 80% Problems in Excel
Free Trial Now

Say goodbye to terrible VBA and formulas!

5. Now the benchmark line series is added to the chart. Right-click the benchmark line series, and select Change Series Chart Type from the context menu. See screenshot:

6. In the Change Chart Type dialog box, please specify the chart type of the new data series as Scatter with Straight Line, uncheck the Secondary Axis option, and click the OK button. See screenshot:

Now you will see the benchmark line is added to the column chart already. Go ahead to decorate the chart.

7. Right click the horizontal X axis, and select Format Axis from the context menu.

8. In the Format Axis pane, please check the On tick marks in the Axis position section on the Axis Options tab.

Now the horizontal benchmark line is added as following screenshot shown:

Add horizontal benchmark/base/target line by adding a new data series in an Excel chart


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Only several clicks to add a horizontal average/benchmark/target/base line to an Excel chart

Comparing to generally adding data series and changing chart type to add a normal horizontal line in a chart in Excel, Kutools for Excel's Add Line to Chart feature provides a fantastically simple way to add an average line, a target, benchmark, or base line to a chart quickly with only several click. Full Feature Free Trial 30-day!

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Add horizontal benchmark/target/base line by Paste Special in Excel chart

This method will guide you to copy the benchmark/target/baseline data to the destination chart as a new data series, and then change the chart type of the new series to Scatter with Straight Line in Excel.

1. Enter your benchmark data in the worksheet as below screenshot shown.

Note: In the screenshot, 12 indicates there are 12 records in our source data; 85 means the benchmark sales, and you can change them as your need.

2. Select the benchmark data (the Range D2:E4 in my example), and press Ctrl + C keys simultaneously to copy it.

Kutools for Excel

Stand out from the Crowd

300 Handy Tools
Solve 80% Problems in Excel
Free Trial Now

Say goodbye to terrible VBA and formulas!

3. Click to activate the original chart, and then click Home > Paste > Paste Special. See screenshot:

4. In the opening Paste Special dialog, please check the New Series option, the Columns option, the Series Names in First Row checkbox, the Categories (X Labels) in First Column checkbox, and then click the OK button. See screenshot:

Now the benchmark data has been added as a new data series in the activated chart.

5. In the chart, right click the new Benchmark series, and select Change Series Chart Type from the context menu. See screenshot:

6. Now the Change Chart Type dialog comes out. Please specify the Chart Type of Benchmark series as Scatter with Straight Lines, uncheck the Secondary Axis option behind it, and then click the OK button. See screenshot:

So far, the benchmark line has been added in the chart. However, the benchmark line neither begins at the outside border of the first column, nor reaches the outside border of the last column.

7. Right click the horizontal X axis in the chart, and select Format Axis from the context menu. See screenshot:

8. In the Format Axis pane, under the Axis Options tab, please check the On tick marks option in the Axis Position section. See screenshot:

Now you will see the benchmark line comes across all column data in the chart. See screenshot:

Notes:

(1) This method can also add horizontal benchmark line in an area chart.

(2) This method can also add horizontal benchmark line in a line chart.

Add horizontal benchmark/target/base line by Paste Special in Excel chart


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Add horizontal benchmark/target/base line in an Excel chart with an amazing tool

If you have Kutools for Excel installed, you can apply its Add Line to Chart feature to quickly add average line, benchmark line, target line, based line, etc. to the currently selected chart in Excel.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

1. Select the chart you will add benchmark line for.

2. Click Kutools > Charts > Add Line to Chart to enable this feature.

3. In the Add line to chart dialog, please check the Other values option, refer the cell containing the specified value or enter the specified value directly, and click the Ok button. See screenshot:

Now the specified benchmark line is added in the selected chart.

Note: You can easily format the benchmark line as you need:
(1) Double click the benchmark line to enable the Format Error Bars pane.
(2) Enable the Fill & Line tab, and you can change the parameters to format the benchmark line freely, says line color, dash type, line width, etc.

300 tools help you stand out from the crowd now

with Kutools for Excel - never worry about job cut

Kutools for Excel brings 300 handy tools for 1500 work scenarios, helps you work faster and better than your colleagues, and easily win trust of your boss. You will be the last one in the list of layoffs, and easily maintain a stable and better life for your family!

  • To be a master of Excel in 3 minutes, and easily win appreciation of others.
  • Improve 80% work efficiency, solve your 80% problems in Excel, not work overtime.
  • Speed up your work, save 2 hours every day to improve yourself and accompany family.
  • Say goodbye to complicated formulas and VBA code, free up your memory.
  • Reduce thousands of keyboard operations and mouse clicks, far away from mouse hand.
  • Spend $39.0, worth more than $4000.0 training of others.
  • Choice of 110,000+ highly effective people and 300+ famous companies, work stable in Excel.
  • Full feature free trial 30-day, no credit card required.
Read More ...
Free Trial Now
 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Guest · 7 months ago
    All was good until Step 8. My vertical bars are truncated on both ends of the data field (as are yours). Thoughts on how to fix this appearance?

Feature Tutorials