How to Add a Vertical Line to a Horizontal Bar Chart

Adding a Data Series

Now we need to add the average value to the chart as a new series. Select the chart. Under the Design menu tab of the Chart Tools section, click on Select Data.

Select Data

In the dialog that appears, click the Add button under Legend Entries to add the Average Value series.

Add Series

Excel will provide an Edit Series dialog to specify the name of the series and the location of the values. For  Series Name, we can type in the title directly:

="Average"

For Series Values, you can specify the two cells that contain the average values calculation. In the example, this will be:

=Sales!$C$18:$C$19

We’ll be back here later once we change these values to a line…

Edit Series

Get the latest Excel tips and tricks by joining the newsletter!

Andrew Roberts ThumbnailAndrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it. You can read more of his writing on his personal blog at NapkinMath.io.

Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!

Other posts in this series...

16 thoughts on “How to Add a Vertical Line to a Horizontal Bar Chart

    1. Hi Bilo!

      The article is broken up into steps to make it easier to follow (it’s very long otherwise!). Please click on the link to page 2 at the bottom or go to step 2 in the Quick Navigation box at the top to get to the next step in the process!

  1. Bilo:

    No, it’s not just you. At the top of the page in the “Quick Navigation Box” there are links to several pages. The first, “1. Building a Basic Horizontal Bar Chart” shows how to create a chart. In order to add a horizontal line, you need to go through all of the links, from 1 to 5.

Leave a Reply

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