Graph colours
in [Charts]
|
Prev: how to: polynomial regression trendline excel 2007
Next: Turn off font Auto Scale globally in Excel 2003?
From: Chris B Chris on 23 Jun 2008 11:53 I have set up an excel file with multiple graphs on one sheet. I seem to have a re-occuring problem where the colours on the graphs change for no reason. I think it is something to do with the pallet setup. For example on my pallet today the bottom right colour is white whereas on Friday it was cream. Subsequently any reference to this position in the pallet is affected by the change. Can you advise as this is causing me severe problems.
From: Jon Peltier on 23 Jun 2008 12:06 Is there a macro which changes the palette? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris B" <Chris B(a)discussions.microsoft.com> wrote in message news:98C47144-D0FF-4EFE-8AA2-A3091F9BB732(a)microsoft.com... >I have set up an excel file with multiple graphs on one sheet. I seem to >have > a re-occuring problem where the colours on the graphs change for no > reason. I > think it is something to do with the pallet setup. For example on my > pallet > today the bottom right colour is white whereas on Friday it was cream. > Subsequently any reference to this position in the pallet is affected by > the > change. > Can you advise as this is causing me severe problems.
From: artemis on 23 Jun 2008 19:53 I have had this happen too. I never quite got to the bottom of why the palette reverted but it seemed to be when data or worksheets from other files using the default palette were copied in. (But only sometimes.) I got round it by keeping a file with the right colour palette on my desktop and copying the palette over to the charts file. this is in Tools/Options/Color in pre 2007 versions. Chris B wrote: > I have set up an excel file with multiple graphs on one sheet. I seem to have > a re-occuring problem where the colours on the graphs change for no reason. I > think it is something to do with the pallet setup. For example on my pallet > today the bottom right colour is white whereas on Friday it was cream. > Subsequently any reference to this position in the pallet is affected by the > change. > Can you advise as this is causing me severe problems.
From: Jon Peltier on 23 Jun 2008 21:24
Are you using the files in both 2003 and 2007? I think 2007 doesn't respect the classic palette, and round tripping the file through 2007 reverts it to the 2003 default. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" <jonxlmvpNO(a)SPAMpeltiertech.com> wrote in message news:%23A5vrsU1IHA.5300(a)TK2MSFTNGP06.phx.gbl... > Is there a macro which changes the palette? > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Tutorials and Custom Solutions > Peltier Technical Services, Inc. - http://PeltierTech.com > _______ > > > "Chris B" <Chris B(a)discussions.microsoft.com> wrote in message > news:98C47144-D0FF-4EFE-8AA2-A3091F9BB732(a)microsoft.com... >>I have set up an excel file with multiple graphs on one sheet. I seem to >>have >> a re-occuring problem where the colours on the graphs change for no >> reason. I >> think it is something to do with the pallet setup. For example on my >> pallet >> today the bottom right colour is white whereas on Friday it was cream. >> Subsequently any reference to this position in the pallet is affected by >> the >> change. >> Can you advise as this is causing me severe problems. > > |