Adding Up/Down Bars to a line chart

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 the Layout tab of the ribbon.
High-Low Lines in Excel 2013
Up/Down Bars in Excel 2013

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

Line chart in Excel 2013

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 2013

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 2013

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

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.