XL98: Chart Is Not Updated When Data Is Changed

• Microsoft Excel 98 Macintosh Edition

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 <workbook>" on the File menu, where <workbook> is the name of the current workbook.

WORKAROUND

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

1. Start Microsoft Excel and create a new workbook.



2. Type the following:

   A1:1 B1:3
   A2:2 B2:4




3. Select A1:B2.



4. On the Standard Toolbar, click the Chart Wizard button.



5. Click the chart type and subtype that you want. Click Next.



6. Click the options you want in steps 2 through 4 of the Chart Wizard. Click Finish.

STATUS

This behavior is by design of Microsoft Excel.

REFERENCES

For more information about charting, click the Office Assistant, type "Chart," click Search, and then click to view "Create a Chart."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

Q179216 OFF98: How to Use the Microsoft Office Installer Program

Additional query words: XL98

Keywords : kbdta kbchart
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug