Display or hide a data table in a chart

Data tables can be displayed in line, area, column, and bar charts. In bar charts, the data table does not replace an axis of the chart but is aligned to the chart.

  1. Click the chart to which you want to add a data table.

  2. On the Chart menu, click Chart Options, and then click the Data Table tab.

  3. To display the chart data in a grid at the bottom of the chart, select the Show data table check box.

    To hide the data table, clear the check box.

Note: To attach the data table to the category axis in a 3-D chart, click 3-D View on the Chart menu, and then select the Right angle axes check box.

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.