Graph colours
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. |
Graph colours
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. |
Graph colours
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. |
Graph colours
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. |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com