Adding Up/Down Bars to a line chart

Excel 2016 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 Chart Design tab of the ribbon:
High-Low Lines in Excel 365
Up/Down Bars in Excel 365

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

Line chart in Excel 365

First way:

To add Up/Down Bars to your chart, select it and then do one of the following:

  • Click on the Chart Elements button, select the Up/Down Bars list, then choose More Options...:
    Chart Elements - Up/Down Bars in Excel 365
  • On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element drop-down list:
    Add Chart Element button in Excel 365

    In the Add Chart Element drop-down list, choose the Error Bars list, then click More Error Bars Options...:

    Up/Down Bars in Excel 365

Second way:

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

Add Lines in Excel 365

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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.