My Pivot Charts always reset the formats whenever I refresh or add
fields. Very frustrating. I checked the "Preserve Formmatting" and
unchecked "AutoFormat" in the pivot table that is used as the source
for the chart, but still doesnt fix my problem. Also have tried making
the chart type I want to use as the "default" but this wasn't of help
either.

Is this normal in excel 2003? Any solutions out there?


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=535013