Microsoft KB Archive/930075

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:35, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


The chart axis that is configured to be displayed in a date format may have a different date format than expected in Excel 2007

Article ID: 930075

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

When you open a workbook that contains a chart in Microsoft Office Excel 2007, the chart axis that is configured to be displayed in a date format may have a different date format than expected.

CAUSE

This issue may occur if the workbook was last saved when the date format in the Regional and Language Options dialog box was configured to use a different date format than the format in which the chart axis was originally formatted.

Note To access the Regional and Language Options dialog box in Microsoft Windows XP, click Start, click Control Panel, and then double-click Regional and Language Options.

WORKAROUND

To work around this issue, reformat the chart axis to use the date format that matches the date format in the Regional and Language Options dialog box.

To do this, follow these steps:

  1. Right-click the chart axis that contains the date, and then click Format Axis.
  2. Click Number, and then click Date under Category. Under Type, click the date format that matches the date format in the Regional and Language Options dialog box.
  3. Click Close.



Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbtshoot kbchart kbprb kbexpertisebeginner KB930075