XL98: Cannot Add a Data Table to Some Charts

ID: Q181660

The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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 kinds of charts:

Column
Bar
Line
Area
Stock
Data tables are not available for the following kinds of charts:
Pie
Xy (scatter)
Doughnut
Radar
Surface
Bubble


STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.


MORE INFORMATION

The ability to add a data table to a chart is a new feature in Microsoft Excel 98. 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, follow these 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.


If you click Data Table on the Chart toolbar, Microsoft Excel adds a data table if the chart does not contain a data table. Microsoft Excel removes the data table if the chart already contains one.

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


REFERENCES

For more information about data tables, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

data tables, charts
and then click Show Topics. Select the "Display or hide a data table in a chart" topic and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL98

Keywords : kbdta kbchart
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.