XL: Embedded Excel 4.0 Chart Incorrect

Last reviewed: February 2, 1998
Article ID: Q129076
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0a, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, if you open a Microsoft Excel 4.0 file that contains an embedded chart, the chart may not show the correct number of categories and the series formulas may be incorrect. If you then reopen the chart in Microsoft Excel 4.0, the chart is displayed correctly.

CAUSE

You may experience these symptoms if the chart was created on a worksheet for which the calculation was set to manual and the chart was saved after you added data to the range of cells from which the chart was created.

WORKAROUND

To work around this problem, use either of the following methods.

Method 1

  1. Start Microsoft Excel, version 4.0

  2. Open the file with the embedded chart.

  3. On the File menu, click Save.

  4. Quit Microsoft Excel, version 4.0

  5. Start Microsoft Excel version 5.0 or 7.0, or Microsoft Excel 98 Macintosh Edition.

  6. Open the file with the embedded chart.

Method 2

  1. Open the file in Microsoft Excel version 5.0 or 7.0, or in Microsoft Excel 98 Macintosh Edition.

  2. Select the embedded chart by clicking it.

  3. Click the Chart Wizard toolbar button. This displays the Chart Wizard dialog box.

  4. Select the correct range of cells on the worksheet for the chart. If you are using Microsoft Excel 7.0 or earlier, this can be changed in step 1. If you are Microsoft Excel 97 or later, this can be changed in step 2.

    This step updates all the series formulas in the chart.

  5. Click Finish.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. >>,

REFERENCES

"User's Guide," version 5.0, Chapter 17, "Changing Data in a Chart"


Additional query words: 5.00 7.00
Keywords : kbtool
Version : WINDOWS:5.0,5.0c,7.0,7.0a; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS
Issue type : kbbug


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.