XL2000: Data Labels Do Not Retain Formatting (296665)
The information in this article applies to:
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 2000 Service Release 1 (SR-1)
- Microsoft Excel 97 for Windows Service Release 1 (SR-1)
- Microsoft Excel 97 for Windows Service Release 2 (SR-2)
This article was previously published under Q296665 OfficeQFE:3427 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. WORKAROUNDTo 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:
| H | I | J | | 12 | =B12 | =D2 | =F13 | | 13 | =B13 | =D4 | =F15 |
You would then graph the range H12:J13. STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 6/6/2003 |
|---|
| Keywords: | kbprb kbbug kbpending KB296665 |
|---|
|