XL2000: Chart Axis May Be Four Years Early After You Format Scale

Article translations Article translations
Article ID: 214348 - View products that this article applies to.
This article was previously published under Q214348
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

When you format an axis in a chart by using a time scale in Microsoft Excel, the axis may begin and end four years too early.

For example, if you want the axis to start at year 1990 and end at year 1999, it may actually start at year 1986 and end in year 1995.

For an example of this problem, see the "More Information" section in this article.

CAUSE

This problem may occur if the following conditions are true:
  • You type a serial date value in the Minimum or Maximum box on the Scale tab in the Format Axis dialog box.

    -and-

  • You are using the 1904 Date System.
NOTE: This problem is more likely to occur in Microsoft Excel for Macintosh than in Microsoft Excel 2000, because Microsoft Excel for Macintosh uses the 1904 Date System by default. The problem does not occur when Microsoft Excel uses the 1900 Date System.

Specifically, the problem occurs because Microsoft Excel uses the 1900 Date System for the serial date values you type in the Minimum and Maximum boxes.

WORKAROUND

To work around this problem, do not type serial date values in the Minimum and Maximum boxes on the Scale tab of the Format Axis dialog box. Instead, type the dates as you would normally type them in a worksheet. For example, use the formats that are in the following table:
   Example            Note
   -------------------------------------------------------------------

   1/10/1998          Month-day-year order
   31/3/1998          Day-month-year order; for most non-United States
                      locales

   October 13, 1998   Fully spelled date
   16 October 1998    Fully spelled date
				

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Properties

Article ID: 214348 - Last Review: October 14, 2013 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB214348

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com