https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/930075&feed=atom&action=history
Microsoft KB Archive/930075 - Revision history
2024-03-29T13:43:04Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/930075&diff=226540&oldid=prev
3155ffGd: importing KB archive
2020-07-18T17:35:30Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB930075"></span>The chart axis that is configured to be displayed in a date format may have a different date format than expected in Excel 2007 =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 930075<br />
<br />
Article Last Modified on 10/15/2007<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Office Excel 2007<br />
<br />
<br />
-----<br />
<br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
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.<br />
<br />
</div><br />
<div class="cause_section"><br />
<br />
== CAUSE ==<br />
<br />
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.<br /><br />
<br /><br />
'''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'''.<br />
<br />
</div><br />
<div class="workaround_section"><br />
<br />
== WORKAROUND ==<br />
<br />
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.<br /><br />
<br /><br />
To do this, follow these steps:<br />
# Right-click the chart axis that contains the date, and then click '''Format Axis'''.<br />
# 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.<br />
# Click '''Close'''.<br />
<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12<br />
<br />
Keywords: kbtshoot kbchart kbprb kbexpertisebeginner KB930075<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd