View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ty Ty is offline
external usenet poster
 
Posts: 72
Default 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..