XL98: Dates Made Consecutive When Charting in Microsoft Excel

Last reviewed: February 2, 1998
Article ID: Q178791
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

If you chart a range of dates that are not consecutive, Microsoft Excel 98 Macintosh Edition may fill in the missing dates to make the range consecutive.

WORKAROUND

To resolve this behavior, format the axis to be a category axis instead of a time-scale axis. To do this, use one of the following methods.

Method 1

If you entered data on the worksheet but did not yet create the chart, follow these steps:

  1. Select the data on the worksheet that is to be the source data for the chart.

  2. Click Chart Wizard on the Standard toolbar.

  3. Make the changes you want in steps 1 and 2 of the Chart Wizard.

  4. In step 3 of the Chart Wizard, click the Axis tab.

  5. Click Category under Category (X) axis.

  6. Continue stepping through the Chart Wizard until the chart is created.

Method 2

If you already created the chart, follow these steps:

  1. Click the chart to select it.

  2. On the Chart menu, click Chart Options.

  3. Click the Axes tab.

  4. Click Category under Category (X) Axis and click OK.

STATUS

This behavior is by design of Microsoft Excel 98.

MORE INFORMATION

Microsoft Excel 98 automatically uses a time-scale axis if it detects that you have worksheet data that contains date number formatting in the first column, or first row of source data for the chart (depending on the dimensions of your source data). The time-scale axis is a special type of category axis that is organized by date. The time-scale axis in the chart displays the dates in chronological order even if the dates are not in that order on the worksheet. The scaling of the time-scale axis is determined by an algorithm Microsoft Excel 98 uses on the range of dates in the axis. The base unit is calculated by scanning through the series of points and finding the smallest time difference between two date values in the range. This time difference then becomes the base unit for the time-scale axis.

REFERENCES

For more information about the time-scale axis, click the Index button in Microsoft Excel 98 Help, type the following text

   time-scale axes

and then double-click the selected text to go to the "About time-scale axes" topic.


Additional query words: XL98
Keywords : xlchart
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.