EXCEL pivot charts

[Nick Thompson]

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://redfish.com/pipermail/friam_redfish.com/attachments/20070314/4d0e2f2b/attachment.html 

[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)
>  
>  
>
>