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

You can add TE000127103 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 TE000127115 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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×