software

My Pivot Charts always reset the formats whenever I refresh or add
fields. Very frustrating. I checked the quot;Preserve Formmattingquot; and
unchecked quot;AutoFormatquot; 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 quot;defaultquot; but this wasn't of help
either.

Is this normal in excel 2003? Any solutions out there?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535013This 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
support.microsoft.com/?id=215904

shadestreet wrote:
gt; My Pivot Charts always reset the formats whenever I refresh or add
gt; fields. Very frustrating. I checked the quot;Preserve Formmattingquot; and
gt; unchecked quot;AutoFormatquot; in the pivot table that is used as the source
gt; for the chart, but still doesnt fix my problem. Also have tried making
gt; the chart type I want to use as the quot;defaultquot; but this wasn't of help
gt; either.
gt;
gt; Is this normal in excel 2003? Any solutions out there?--
Debra Dalgleish
Contextures
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: www.excelforum.com/member.php...foamp;userid=7092
View this thread: 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: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535013Based on the information in David Gainer's blog this week, it looks like
it will be fixed in Excel 2007:

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

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

shadestreet wrote:
gt; n/m
gt;
gt; my eyesight is poor... it was in earlier editions, probably means it
gt; won't be fixed next edition either.
gt;
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Excellent... any clue when Office 2007 comes out?--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535013This article says some users will get it in October 2006, and others in
January 2007:www.microsoft.com/presspass/p...eTimingPR.mspx
shadestreet wrote:
gt; Excellent... any clue when Office 2007 comes out?
gt;
gt;--
Debra Dalgleish
Contextures
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: www.excelforum.com/member.php...foamp;userid=7092
View this thread: www.excelforum.com/showthread...hreadid=535013