Microsoft KB Archive/940516

= The labels on the vertical axis of a chart may wrap when you open a workbook in Excel 2007 =

Article ID: 940516

Article Last Modified on 9/11/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

-



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
You open a workbook that contains a chart that has labels on the vertical axis. If you save the workbook in Microsoft Office Excel 2007 and then reopen the workbook, the labels on the vertical axis of the chart may wrap. This may cause the chart to appear incorrect.



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

938541 Description of the Excel 2007 hotfix package: June 11, 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 this hotfix, follow these steps:  Exit Excel 2007. Start Registry Editor. To do this, use one of the following methods:  In Windows Vista, click Start, type regedit in the Start Search box, and then press ENTER.

If you are prompted for an administrator password or for a confirmation, type the password, or click Continue. In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK.  Locate and then click the following registry subkey:

 

Note If the Charting subkey does not exist, create the subkey. To do this, follow these steps:  Click to select the Common subkey.</li> On the Edit menu, point to New and then click Key.</li> Type Charting, and then press ENTER.</li></ol> </li> After you select the subkey that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.</li> Type InsideOutAxisBorderReduction, and then press ENTER.</li> Right-click InsideOutAxisBorderReduction, and then click Modify.</li> In the Value data box, type a value between 1 and 5 to adjust the default border size of the converted chart, and then click OK.

Note By default, the border width on the converted chart is 5 pixels wide. This registry value is the number of pixels to subtract from the border width. For example, if you set this registry value to 1, the converted chart will have a border width of 4 pixels. If you set this registry value to 5, the converted chart will have a border width of 0 pixels.</li> On the File menu, click Exit to 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.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbbug kbfix kbchart kbqfe kbconversion kbpubtypekc kbopenfile kbexpertiseinter kbhotfixserver kboffice2007postrtmfix KB940516

-

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

© Microsoft Corporation. All rights reserved.