Display or hide a data table in a chart

Microsoft Office Excel 2003

Show All Show All

Display or hide a data table in a chart

  1. Click the line, area, column or bar 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 or hide the chart data in a grid at the bottom of the chart, select or clear the Show data table check box.

Notes

  • In bar charts and charts with time-scale axes, the data table does not replace an axis of the chart but is aligned to the chart.

  • 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.