Excel 2003 Color on Pivot Chart

's Computer Specifications

In Excel 2003 I do the following:

Format Data Series

Pattern Tab->Area->None
Select my color
Hit OK

Everything is fine.

The problem is when I right click my pivot info and select the "!" for
REFRESH.

PROBLEM:
Color changes back

Is there a way to keep the selected color?

Thanks in advance..

's Computer Specifications

Hi,

This is a know problem,
http://www.contextures.com/xlfaqPivot.html#ChartFormat

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ty" <(E-Mail Removed)> wrote in message
news:1b239f20-ae32-47fe-a38e-(E-Mail Removed)...
> In Excel 2003 I do the following:
>
> Format Data Series
>
> Pattern Tab->Area->None
> Select my color
> Hit OK
>
> Everything is fine.
>
> The problem is when I right click my pivot info and select the "!" for
> REFRESH.
>
> PROBLEM:
> Color changes back
>
> Is there a way to keep the selected color?
>
> Thanks in advance..

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007	ronny B	Microsoft Excel Charting	2	5th Jan 2009 01:02 PM
Excel 2003 - Pivot chart	laurence.matthey@bluewin.ch	Microsoft Excel Discussion	1	24th May 2008 11:05 PM
Excel 2007 pivot chart/table copying vs Excel 2003	xpdnt1	Microsoft Excel Charting	0	6th May 2008 08:51 PM
CHART COLOR SCHEMES IN EXCEL 2003	=?Utf-8?B?U3Bhcmtl?=	Microsoft Excel Misc	4	5th Mar 2005 12:45 AM
how to set background color in pivot table excel 2003?	=?Utf-8?B?U0wgV29uZw==?=	Microsoft Access Forms	1	26th May 2004 12:38 PM