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

This is a known problem with pivot charts. There's information in the
following MSKB article, which suggests recording a macro as you apply
the formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904

shadestreet wrote:
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?


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

Thanks Debra...

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


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

n/m

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


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

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

Excellent... any clue when Office 2007 comes out?


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

This article says some users will get it in October 2006, and others in
January 2007:


http://www.microsoft.com/presspass/p...eTimingPR.mspx



shadestreet wrote:
Excellent... any clue when Office 2007 comes out?




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

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

(not that I am complaining)


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