Excel: Closed Worksheet Number Formats Do Not Appear on Chart

 Last reviewed: November 30, 1994
Article ID: Q81563
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.x and 3.0

SUMMARY

In Microsoft Excel versions 3.0 and later, built-in number formats are displayed on charts whether or not the supporting worksheet is open. However, if the format is a custom (that is, not built-in) format, the supporting worksheet must be open in order for the format to display.

In Excel 5.0, if the data with a custom format is in the same book as the chart, this behavior does not occur. However, if you move the chart into a new book, the supporting workbook must be open for the custom number formats to display correctly on the chart.

MORE INFORMATION

In Excel versions earlier than 3.0, the format of values on a chart is updated only if the supporting document is open. This applies to all number formats. If the worksheet is closed, the values appear on the chart in default formats.

In worksheets, as opposed to charts, information is always displayed according to the format applied to the cell that contains it. In this case, formatting for linked information is in no way dependent on supporting documents.

REFERENCES

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 178-179

"Microsoft Excel User's Guide," for the Macintosh, version 3.0, pages 180-182

KBCategory: kbother
KBSubcategory:

Additional reference words: 2.x 3.00 4.00a 4.00 5.00 number formats
serial number

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.