Show or hide a chart legend or data table

When you create a chart, the legend 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

Show or hide a data table

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.

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

    Excel Ribbon Image

  3. Do one of the following:

    • To hide the legend, click None.

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

    • To display a legend, click the display option that you want.

      Note   When you click one of the display options, the legend moves, and the plot area automatically adjusts to accommodate it. If you move and size the legend by using the mouse, the plot area does not automatically adjust.

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

      Tip   By default, a legend does not overlap the chart. If you have space constraints, you may be able to reduce the size of the chart by clearing the Show the legend without overlapping the chart check box.

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.

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

    Excel Ribbon Image

  3. 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, 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

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



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language