Add or remove predefined lines or bars in a chart

To help you analyze the data that is displayed in a chart, you can add predefined lines or bars (such as series lines, drop lines, high-low lines, and up-down bars) to specific charts (such as 2-D stacked bar and column charts, line charts, pie of pie and bar of pie charts, area charts, and stock charts). If you no longer want to display the lines or bars, you can remove them.

Stacked column chart with series lines displayed

In this article


Predefined line and bar types that you can add to a chart

Specific line and bar types are available in 2-D stacked bar and column charts, line charts, pie of pie and bar of pie charts, area charts, and stock charts. Depending on the chart type that you use, you can add one of the following lines or bars:

Series Lines

Drop Lines

  • High-low lines    Available in 2-D line charts and displayed by default in stock charts, high-low lines extend from the highest value to the lowest value in each category.

High-Low Lines

  • Up-down bars    Useful in line charts with multiple data series, up-down bars indicate the difference between data points in the first data series and the last data series. By default, these bars are also added to stock charts, such as Open-High-Low-Close and Volume-Open-High-Low-Close.

Up-Down Bars

Top of Page Top of Page

Add predefined lines or bars to a chart

  1. Click the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stock chart to which you want to add lines or bars.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Layout tab, in the Analysis group, do one of the following:
    • Click Lines, and then click the line type that you want.

 Note   Different line types are available for different chart types.

  • Click Up/Down Bars, and then click Up/Down Bars.

Analysis group on the Layout tab (Chart Tools)

 Tip   You can change the format of the series lines, drop lines, high-low lines, or up-down bars that you display in a chart by right-clicking the line or bar, and then clicking Format <line or bar type> .

Top of Page Top of Page

Remove predefined lines or bars from a chart

  1. Click the 2-D stacked bar, column, line, pie of pie, bar of pie, area, or stock chart that displays predefined lines or bars.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Layout tab, in the Analysis group, click Lines or Up/Down Bars, and then click None to remove lines or bars from a chart.

Analysis group on the Layout tab (Chart Tools)

 Tip   You can also remove lines or bars immediately after you add them to the chart by clicking Undo on the Quick Access Toolbar or by pressing CTRL+Z.

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Outlook 2010, PowerPoint 2010, Word 2010