Microsoft KB Archive/184364

= XL98: Chart Is Not Updated When Data Is Changed =

Article ID: 184364

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184364



SYMPTOMS
When you change cells that are linked to a chart, the chart may not be updated.



CAUSE
This problem occurs if you do the following conditions:


 * 1) You create a chart by using Microsoft Graph 98.
 * 2) You copy data from a Microsoft Excel worksheet.
 * 3) In Microsoft Graph 98, you click Paste Link on the Edit menu to insert the Microsoft Excel data into the datasheet.
 * 4) In Microsoft Graph 98, you click "Quit & Return to " on the File menu, where is the name of the current workbook.



WORKAROUND
To work around this problem, create the chart in Microsoft Excel by using the following steps.

 Start Microsoft Excel and create a new workbook. Type the following:

A1: 1 B1: 3

A2: 2 B2: 4

 Select A1:B2. On the Standard Toolbar, click the Chart Wizard button. Click the chart type and subtype that you want. Click Next. Click the options you want in steps 2 through 4 of the Chart Wizard. Click Finish.</li></ol>

A chart that is linked to the data is visible in the worksheet.

<div class="status_section">

STATUS
This behavior is by design of Microsoft Excel.

<div class="references_section">