Formatting Problems with Pivot Charts

S

shadestreet

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

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

shadestreet

Thanks Debra...

Was this a problem in earlier versions of Excel? The Microsoft sit
only mentioned 2003 editions. Hopefully this will be fixed in the nex
version
 
S

shadestreet

n/m

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

shadestreet

Strange, I have realized that I have two charts that maintain thei
properties after I refresh data (one uses stacked columns a
chart-type, another keeps the chart title). Why would these charts b
unaffected by the refresh-bug?

(not that I am complaining
 
Top