View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Colour scheme changes when copying

Truly bizarre. What version of Excel?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"rossu" wrote in message
...
The graphs were all in the same workbook. I just inserted a new
worksheet.
All three were copied to the same worksheet and all three got given new
colour schemes, all different

"Jon Peltier" wrote:

The color scheme (i.e., "palette") of the new workbook needs to be
matched
to that of the workbook containing the charts. With the new workbook
active,
go to Tools menu Options Color. In the Copy Colors From dropdown at
the
bottom, select the open workbook with the color palette you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"rossu" wrote in message
...
I had three surface(contour) plots on which I was using a custom colour
scheme (various greys). In order to make sure that all three had
exactly
the
same colour scheme, I created a blank spreadsheet and copied and pasted
each
graph onto the page. When I did, the colour scheme changed! It was
different every time I pasted the graph. It looks like the fill colour
scheme was put back to automatic when I pasted. The program also chose
a
different design colour scheme for each chart. I don't think this
should
be
happening!