Adding Up/Down Bars to a line chart

Excel 365 2013 2010 2007
If you have a line chart with two different data series, you might want to compare those series at each point along the horizontal axis. There are two different options for this, available in two locations, along with the Design tab, under Chart Tools of the ribbon.
High-Low Lines in Excel 2016
Up/Down Bars in Excel 2016

Create a line chart with two different data series, for example:

Line chart in Excel 2016

First way:

To add Up/Down Bars to your chart, select it and then under Chart Tools, on the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose Up/Down Bars list:

Add Chart Element in Excel 2016

In the Up/Down Bars drop-down list, select Up/Down Bars.

Second way:

To add High-Low Lines to your chart, select it and then under Chart Tools, on the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose Lines list:

Add Chart Element in Excel 2016

In the Lines drop-down list, select High-Low Lines.

See also this tip in French: Ajouter de barres Haut / Bas à un graphique en courbes.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.