Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107752

From BetaArchive Wiki

Microsoft Knowledge Base

XL: Chart Number Format Not Updated If Data Source External

Last reviewed: March 27, 1997
Article ID: Q107752

5.00 5.00c 7.00| 5.00 5.00a

WINDOWS        | MACINTOSH

kbusage kbtlc

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.

The numbers on the chart are still formatted with the General format and do not reflect the percentage format that you applied to the linked data in BOOK2.XLS.

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

KBCategory: kbusage kbtlc

KBSubcategory:

Additional reference words: 5.00 7.00
Keywords : kbtlc kbusage
Version : 5.00 5.00c 7.00| 5.00 5.00a
Platform : MACINTOSH WINDOWS


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: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.