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:


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


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

Edit Series