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 <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; The Friday Morning Applied Complexity Coffee Group <[email protected]> > 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:[EMAIL PROTECTED] > > Sent: Wednesday, March 14, 2007 11:01 PM > > To: [email protected] > > 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 > > ([EMAIL PROTECTED]) Research Associate, Redfish Group, > > Santa Fe, NM ([EMAIL PROTECTED]) > > > > > > > > ============================================================ FRIAM Applied Complexity Group listserv Meets Fridays 9a-11:30 at cafe at St. John's College lectures, archives, unsubscribe, maps at http://www.friam.org
