Plot lines that contain labels disappear when you edit a Microsoft Excel chart or a Microsoft Graph chart in an Office 2003 program

Article translations Article translations
Article ID: 931663 - View products that this article applies to.
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
Expand all | Collapse all

On This Page

SYMPTOMS

When you edit a Microsoft Excel chart or a Microsoft Graph chart in a Microsoft Office 2003 program, plot lines that contain labels disappear. This issue occurs if the following conditions are true:
  • You saved the files that contain the Excel chart or the Graph chart in an earlier version of a Microsoft Office program.
  • The chart has values that are displayed as plot lines that contain labels.

RESOLUTION

This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix.

Service pack information

This problem is corrected in Office 2003 Service Pack 3. To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
870924 How to obtain the latest service pack for Office 2003

After you install the service pack, follow the steps that are listed in the "How to enable the hotfix" section of the article to set the
QFE_Bonn
registry key and to activate the hotfix.

Hotfix information

If the issue occurs in an Excel chart, see the following article in the Microsoft Knowledge Base to resolve this issue:
811161 Data labels disappear if value is greater than axis maximum in Excel 2002 and in Excel 2003
If the issue occurs in a Graph chart, apply the hotfix that is described in this article to resolve this issue.

How to obtain the hotfix

This issue is fixed in the Office 2003 post-Service Pack 2 (KB931662) Hotfix Package that is dated January 26, 2007. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
931662 Description of the Office 2003 post-Service Pack 2 hotfix package: January 26, 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:
  1. Exit all Office 2003 programs.
  2. Click Start, click Run, type regedit, and then click OK.
  3. Locate and then click the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
  4. After you select the subkey that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.
  5. Type QFE_Bonn, and then press ENTER.
  6. Right-click QFE_Bonn, and then click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. On the File menu, click Exit to exit Registry Editor.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was first corrected in Office 2003 Service Pack 3.

Properties

Article ID: 931663 - Last Review: October 8, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Office Basic Edition 2003
  • Microsoft Office Professional Edition 2003
  • Microsoft Office Small Business Edition 2003
  • Microsoft Office Access 2003
  • Microsoft Office Outlook 2003
  • Microsoft Office PowerPoint 2003
Keywords: 
kboffice2003sp3fix kboffice2003presp3fix kbexpertiseinter kbregistry kbchart kbqfe kbbug kbfix KB931663

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