XL98: Chart Data Table Does Not Display All Data Points

• Microsoft Excel 98 Macintosh Edition

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:

             a. Click anywhere on the data table in the chart.

             b. On the Format menu, click Selected Data Table.

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

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:

   data tables, charts