Skip to content

Add a Target Line to Your Bar Graph

This article will show you how to take your bar graph and add a line indicating a target value.

This design technique can make your graph easier to read if you are using it to see which metrics meet a specific target.

If you’d like to learn how to add this feature to your bar graph in Excel, then keep reading.

Step 1 – Add the Target Metric

The first step is to add the target number to the cells next to your already existing data. You want to repeat your target number down the column for each data point.

With your target data set up, you can move to step 2.

Step 2 – Add the Target Data to Your Chart

The next step is to add the target data to your chart.

To do this, right-click on the chart and click on Select Data.

Next, click on the Add button to add a data series.

Give the series the name “Target,” and select the Target data range for the series values.

Finally, click on Ok and then Ok. Your graph should now look something like this.

Step 3 – Change the Chart Type

At this point, right-click on the chart again and select Change Chart Type.

At the bottom of the list, click on Combo.

Select Clustered Column for Series1, and select Line for Target.

Finally, click on Ok. You now have a bar chart with a line indicating a specific target value!

See It In Action

To see how this all works, check out the video below!

This Post Has One Comment

  1. I learned this technique from your short and I’ve used it in some of my graphs! Thanks for posting this!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top