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.

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 wrote in message
...
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.

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.

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" wrote in message
...
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 wrote in message
...
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.