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