Add up-down bars and drop, series, and high-low lines to charts

You can add series lines to connect data series in 2-D stacked bar and column charts. Drop lines are available in 2-D and 3-D area and line charts. High-low lines and up-down bars are available in 2-D line charts. Stock charts already have high-low lines and up-down bars.

To add these lines and bars to all data series of the same chart type, select only a single data series.

  1. Click a data series in the chart that you want to add bars or lines to.

  2. On the Format menu, click Selected Data Series, and then click the Options tab.

  3. Select the option for the type of lines or bars you want.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.