Microsoft KB Archive/296665

= XL2000: Data Labels Do Not Retain Formatting =

Article ID: 296665

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2000 Service Pack 1
 * Microsoft Excel 97 Service Pack 1
 * Microsoft Excel 97 Service Pack 2

-



This article was previously published under Q296665





SYMPTOMS
After you format the data labels on an Excel graph, the data labels may not be retained when you open the file again.



CAUSE
This problem may occur if the source data range for the graph contains several hidden columns or rows. This condition creates hidden series.



WORKAROUND
To work around this problem, create a table on which the graph will be based. Link each cell of the table to the source cell in the worksheet, whether or not the source cell is hidden. This makes it possible for you to graph data that is in rows or columns that are not adjacent to each other. Also, by linking to the cell data, you can have automatic updates of the data when it is changed in the source cell.

For example: The source cells are B12, B13, D2, D4, F13, and F15. The table is located in the range H12:J13 and contains the following formulas linking the table cells to the sources cells:

You would then graph the range H12:J13.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbprb kbbug kbpending KB296665

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.