Home » Microsoft Excel 2003 » 06 - Creating Charts
6

Display or Hide a Data Table in a Chart

If you want, you can show the actual data table a chart is based on inside the chart itself.

  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.

The chart data looks like this:

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.