Show All

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.

   For Help on an option, click the question mark and then click the option.