Uh-oh. My question is unclear. Where you sent me is a wonderful place to
go if I want to change the palette from which the program works. But I
dont see anything there what will preserve my color choices from chart to
chart, unless the charts are rendered as pictures. And at that point, i
cannot change the page variable settings in the picture version, and if I
change it in the pivot chart version, I lose my color selections again.
Since I posted my question, I have come accross an application from jobsoft
(forty bucks) that does all the specific tasks that I have been trying to
get XL to do for several days. Chart Tools. I am trying out the trial
version now.
Nick
> [Original Message]
> From: Stephen Guerin <stephen.guerin at redfish.com>
> To: <nickthompson at earthlink.net>; The Friday Morning Applied Complexity
Coffee Group <friam at redfish.com>
> Date: 3/14/2007 11:19:06 PM
> Subject: RE: [FRIAM] EXCEL pivot charts
>
> 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)
> >
> >
> >
> >
Locked
