Microsoft Knowledge Base

WINDOWS        | MACINTOSH

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When you change the number format of the source data for a Microsoft Excel chart, the number format of the data in the chart is not updated if the following conditions are true:

    - The source data is in another workbook

      -and-

    - The chart sheet is not the active sheet in its workbook

CAUSE

When you create a chart in one workbook that contains data from another workbook, the format of the chart data will be updated only when the chart sheet is active and the workbook that contains the source data is open.

WORKAROUND

To make sure that your chart data formats are updated when you change the format of the source data, do either of the following:

• Keep the source data worksheet and the chart in the same workbook.

  -or-

• Activate the chart window before you change the format of the source data.

Steps to Reproduce Behavior

1. In a new workbook that contains at least two worksheets, in one of the worksheets, enter the following data:

         A1: 1
   

2. Select cell A1 and press F11 to create a chart that is a new sheet in the workbook.

3. Do the following to drag the sheet on which you entered the data to a new workbook:

   a. From the File menu, choose New to create a new workbook (Book2 in

         this example).
   

   b. From the Window menu, choose Arrange, and under Arrange, select the

         Tiled option.
   

   c. Select the tab of the worksheet with the chart data and drag it to

         the Book2 window.
   

   d. Save the new workbook as BOOK2.XLS.

4. In the first workbook, select the tab of another worksheet so that the chart sheet is not the active sheet.

5. In the worksheet that you moved to BOOK2.XLS, select cell A1, and from the Format menu, choose Cells. Select the Number tab, and from the Category list, choose Percentage. From the Format Codes list, choose 0%, and choose OK.

6. In BOOK2.XLS, from the File menu, choose Close, and choose Yes to save the changes.

7. In the first workbook, select the chart sheet tab.

NOTE: If the chart sheet is active in the first workbook at any time while BOOK2.XLS is open, the values on the chart have the same formatting as the linked data.

REFERENCES

For more information about Creating A Chart Sheet In A Workbook, choose the Search button in Help and type:

    creating, chart sheets