[FRIAM] EXCEL pivot charts

[Stephen Guerin]

Nick,

How about messing with tools->options->colors? 

> -----Original Message-----
> From: Nicholas Thompson [mailto:nickthompson at earthlink.net] 
> Sent: Wednesday, March 14, 2007 11:01 PM
> To: friam at redfish.com
> Subject: [FRIAM] EXCEL pivot charts
> 
> All or Any, 
>  
> I am trying to create a set of pivot charts from the same 
> data using the same color scheme i.e., so that each data 
> series has the same color in each of sixteen charts.  
>  
> The default color scheme provided by Excel is drab and awful 
> and I want to use my own.  
>  
> the trouble is that each time I change a page variable in the 
> pivot chart, the chart REVERTS TO THE DEFAULT COLORS.  
>  
> This means I have to imput the color scheme sixteen different times. 
>  
> Has anybody ever encountered this problem and conquered it. 
>  
> NIck
>  
>  
>  
>  
> Nicholas S. Thompson
> Professor of Psychology and Ethololgy, Clark University 
> (nthompson at clarku.edu) Research Associate, Redfish Group, 
> Santa Fe, NM (nick at redfish.com)
>  
>  
> 
>