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

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" <tyrone_bak@yahoo.com> wrote in message
news:1b239f20-ae32-47fe-a38e-4b6037b8db75@a70g2000hsh.googlegroups.com...
> 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..