Show or hide a chart legend or data table

When you create a chart, the legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) appears by default, but you can hide the legend or change its location after you create the chart.

You can also show a data table for a line chart, area chart, column chart, or bar chart. A data table displays the values that are presented in the chart in a grid at the bottom of the chart. A data table can also include the legend keys.

For information about creating a chart, see Create a chart.

What do you want to do?


Show or hide a legend

  1. Click the chart in which you want to show or hide a legend.

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

  1. On the Layout tab, in the Labels group, click Legend.

Excel Ribbon Image

  1. Do one of the following:

Top of Page Top of Page

Show or hide a data table

  1. Click the chart of a line chart, area chart, column chart, or bar chart in which you want to show or hide a data table.

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

  1. On the Layout tab, in the Labels group, click Data Table.

Excel Ribbon Image

  1. Do one of the following:
    • To display a data table, click Show Data Table or Show Data Table with Legend Keys.
    • To hide the data table, click None.

       Tip   To quickly remove a data table from a chart, you can select it, and then press DELETE. You can also right-click the data table, and then click Delete.

    • For additional options, click More Data Table Options, and then select the display option that you want.

       Tip   If you already display a legend in the chart, you can clear the Show legend keys check box.

 Note   In bar charts and charts that display a date axis (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.), the data table is not attached to the horizontal axis of the chart — it is placed below the axis and aligned to the chart.

Top of Page Top of Page

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