Formatting Problems with Pivot Charts

[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

 

[Debra Dalgleish]

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]

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

 

[shadestreet]

n/m

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

 

[Debra Dalgleish]

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/2006/04/19/579649.aspx

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

 

[shadestreet]

Excellent... any clue when Office 2007 comes out

 

[Debra Dalgleish]

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


http://www.microsoft.com/presspass/press/2006/mar06/03-24OfficeTimingPR.mspx

 

[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