Adding a horizontal Benchmark/Baseline/Target Line to a Chart or Graph

This post will teach you how to add a horizontal benchmark line to an existing Excel chart 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 Graph

To 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. Then select benchmark line column as its series values. Then click OK button.

#6 you will see that the benchmark line column has been added into the cart.

#7 Right-click on the newly benchmark line series, and select Change Series Chart Type from the drop down menu list. The Change Chart Type window will appear.

#8 Select chart type as line for the benchmark line series.

So far, the horizontal benchmark line or baseline is added into the existing chart.