Excel 2003 Color on Pivot Chart
 

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..

Excel 2003 Color on Pivot Chart
 

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" wrote in message
...
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..