Microsoft KB Archive/192212

= XL98: Embedded Excel 4.0 Chart Incorrect =

Article ID: 192212

Article Last Modified on 6/27/2007

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q192212





SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, 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 containing the embedded chart.
 * 3) On the File menu, click Save.
 * 4) Quit Microsoft Excel, version 4.0.
 * 5) Start Microsoft Excel 98 Macintosh Edition.
 * 6) Open the file containing the embedded chart.

Method 2

 * 1) Open the file 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. You can change this in step 2.

This step updates all the series formulas in the chart.
 * 1) Click Finish.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

Additional query words: XL98

Keywords: kbbug kbchart kbconversion kbfix KB192212

-

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

© Microsoft Corporation. All rights reserved.