Based on the information in David Gainer's blog this week, it looks like
it will be fixed in Excel 2007:

http://blogs.msdn.com/excel/archive/...19/579649.aspx

"If you refresh the data for your PivotChart, the chart updates and the
formatting does not change."

shadestreet wrote:
n/m

my eyesight is poor... it was in earlier editions, probably means it
won't be fixed next edition either.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html