Hi All - I'm using Excel 2003 and have a pivot chart with the values of the
data series displaying as data labels. When I choose different values in
pivot table and the chart refreshes, I lose the labels and have to set them
up again. Is there anyway to keep the labels and have them refresh based on
the revise pivot data?

Thanks in advance!

When pivot tables are recomputed, the associated charts are likely to lose
any custom formatting, which includes data labels. Microsoft suggests
recording a macro the next time you fix a pivot chart, and rerun the macro
as needed.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"THuffman" wrote in message
...
Hi All - I'm using Excel 2003 and have a pivot chart with the values of
the
data series displaying as data labels. When I choose different values in
pivot table and the chart refreshes, I lose the labels and have to set
them
up again. Is there anyway to keep the labels and have them refresh based
on
the revise pivot data?

Thanks in advance!