XL97: Cannot Add a Data Table to Some Charts

• Microsoft Excel 97 for Windows

SYMPTOMS

When you create a chart and click Chart Options on the Chart menu, the Data Table tab does not appear, and you cannot add a data table to the chart.

CAUSE

Data tables are available only in the following charts:

   Column
   Bar
   Line
   Area
   Stock

   Pie
   XY (scatter)
   Doughnut
   Radar
   Surface
   Bubble

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

The ability to add a data table to a chart is a new feature in Microsoft Excel 97. A data table you add to a chart is a grid that contains the numeric data you used to create the chart. Each row in the data table represents a data series. The data table is usually attached to the category axis of the chart and replaces the tick-mark labels on the category axis.

To add a data table to a chart, use the following steps:

1. Click the embedded chart or click the chart sheet.

2. On the Chart menu, click Chart Options.

3. Click the Data Table tab and click "Show data table."

4. Click OK.

NOTE: If you activate a chart type that does not support data tables, the button on the Chart toolbar is disabled.

REFERENCES

For more information about data tables, click the Index tab in Microsoft Excel Help, type the following text

   data tables