XL98: Chart Data Table Does Not Display All Data Points (179046)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q179046 SYMPTOMS
When you display a data table in a chart that you create from a large
number of data points, not all the data points in the series appear in the
data table. Additionally, some labels in the data table may appear
truncated.
CAUSE
This behavior occurs if there is not enough space in the chart. This
behavior is especially noticeable when you use a data series with many data
points.
WORKAROUND
To display more data points in the data table, use one of the following
methods.
Method 1: Reduce the font size you use in the data table. By reducing the
font size, you allow more data points to appear in the data
table. To reduce the font size, follow these steps:
- Click anywhere on the data table in the chart.
- On the Format menu, click Selected Data Table.
- Click the Font tab, choose a smaller font size in the Size
box, and click OK.
Method 2: If the chart is embedded, increase the size of the chart. You
can increase the chart size by clicking and dragging one of the
handles on the edge of the chart.
Note that while these workarounds allow you to display more data points in
the data table, there may not be sufficient room to display all of the data
points in a large series.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
REFERENCES
For more information about data tables, click Contents and Index on
the Help menu. Click the Index button, and type the following text:
and then double-click the selected text to go to the "Display or hide a
data table in a chart" topic.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbchart kbprb KB179046 |
|---|
|