View Single Post
  #6   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

As you've noticed, the color system in 2007 is way different than anything
that came before. I would have expected a chart copied within the same
workbook to retain its formatting, but I would also not be surprised if it
didn't. I'll look into this and file a bug if I replicate your observed
behavior.

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


"rossu" wrote in message
...
2007. I use XL a lot ad I've never seen this before.

"Jon Peltier" wrote:

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!