If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table chart - Data labels
Hi - I have a pivot table and chart. When I change
something in the pivot table, my data labels in the chart disappear. I add then back and then they disappear next time I change the table. When I say "change", I mean just choosing a different item in one of the drop downs and not changing the layout or anyhting drastic. Any help on how to make the dta labels stay would be appreciated. thx, Rick |
#2
|
|||
|
|||
Pivot table chart - Data labels
Rick -
Microsoft admits to having added that feature to pivot charts, and suggests recording a macro the first time you reset formatting, to use every subsequent time you refresh the pivot table: XL2000: Changing a PivotChart Removes Series Formatting (215904) http://support.microsoft.com/?id=215904 - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Rick wrote: Hi - I have a pivot table and chart. When I change something in the pivot table, my data labels in the chart disappear. I add then back and then they disappear next time I change the table. When I say "change", I mean just choosing a different item in one of the drop downs and not changing the layout or anyhting drastic. Any help on how to make the dta labels stay would be appreciated. thx, Rick |
Thread Tools | |
Display Modes | |
|
|