Microsoft KB Archive/938628

= The axis units in a chart in Excel 2007 adjust at different chart heights than in Excel 2003 =

Article ID: 938628

Article Last Modified on 7/6/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SYMPTOMS
In Microsoft Office Excel 2007, the major scale axis units, the minor scale axis units, and the maximum scale axis units adjust at different chart heights than in Microsoft Office Excel 2003. Therefore, charts may not have a uniform appearance when you convert an Excel 2003 chart to Excel 2007.



How to obtain the hotfix
This issue is fixed in the Excel 2007 Hotfix Package that is dated June 4, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

938190 Description of the Excel 2007 hotfix package: June 4, 2007

How to enable the hotfix
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To enable the hotfix, you must create a registry key. To enable this hotfix and to lock the axis units when you convert an Excel 2003 chart to Excel 2007, follow these steps:  Click Start, click Run, type regedit, and then click OK. Click the following registry key:

 Right-click the registry key that si specified in step 2, point to New, and then click DWORD Value. Type LockScaleValuesWhenConvert2003, and then press ENTER. Right-click LockScaleValuesWhenConvert2003, and then click Modify. In the Value data box, type 1, and then click OK. Exit Registry Editor.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbbug kbchart kbqfe kbformat kbdisplay KB938628

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.