Colors different when move Excel to Powerpoint?

[Al Franz]

Using the latest version of Microsoft office tools. I cut and copy a chart
from Excel and paste it into a Powerpoint presentation. But the background
color of my cells which are a light pale yellow in Excel become a very
bright yellow in Powerpoint. The colors are not even close, can this be
controlled.

 

[Steve Rindsberg]

Using the latest version of Microsoft office tools. I cut and copy a chart
from Excel and paste it into a Powerpoint presentation. But the background
color of my cells which are a light pale yellow in Excel become a very
bright yellow in Powerpoint. The colors are not even close, can this be
controlled.

I ran into something vaguely similar just today.

Tell me, if you ungroup the pasted Excel content, do the colors change back to
what they should look like?

And does this happen with all colors or just some?

 

[Al Franz]

Ungrouping had no effect. Dark Red/Brown color I have in my spreadsheet
converts to Powerpoint accurately. The light yellow/beige converts to a
very bright yellow though.

 

[Al Franz]

Steve,

I was able to change the color in the Excel file to get what I wanted in
Powerpoint. I guess it is not a one to one translation though always.

 

[Echo S]

Select the object, and on your Picture Toolbar, click "recolor picture."
Choose to recolor to entire color scheme.

See http://www.echosvoice.com/charts.htm and also
http://www.echosvoice.com/colorschemes.htm

 

[Steve Rindsberg]

Ungrouping had no effect. Dark Red/Brown color I have in my spreadsheet
converts to Powerpoint accurately. The light yellow/beige converts to a
very bright yellow though.

Do you happen to recall the RGB value for the yellow/beige color?
I'd like to see if the same thing happens here.

Also, what version of PPT/Excel do you have?

 

[Al Franz]

Using the latest release of Excel 2003. Select Format/AutoFormat then
select "Colorful 2". If you import that yellow color into Powerpoint I
ended up with a bright Yellow. I just adjusted my Excel file to a more
faint yellow and it did get better. Still interesting that I saw such a
discrepancy though with that yellow.

 

[Echo S]

It probably has to do with the slide color scheme. The light yellow is being
replaced with the appropriate color from the PPT color scheme -- in this
case, it is by coincidence also yellow, albeit a brighter yellow.

 

[Steve Rindsberg]

Using the latest release of Excel 2003. Select Format/AutoFormat then
select "Colorful 2". If you import that yellow color into Powerpoint I
ended up with a bright Yellow. I just adjusted my Excel file to a more
faint yellow and it did get better. Still interesting that I saw such a
discrepancy though with that yellow.

I'd call this a bug, probably in the AutoFormatting or the way PPT deals with
it. I played with this a bit and found that if I formatted rows/columns myself
rather than letting AF do it, everything seemed to paste or paste/link as
expected into PPT.

Autoformatted stuff pasted with the oddly bright yellow you're seeing, and if I
paste/link, I get a strange, spotty gray instead.

Note to self: Customize AutoFormat OFF the menu in Excel. Some of the formats
seem ok, some are utterly intractible.

Thanks for the detailed report, Al.

 

[Steve Rindsberg]

It probably has to do with the slide color scheme. The light yellow is being
replaced with the appropriate color from the PPT color scheme -- in this
case, it is by coincidence also yellow, albeit a brighter yellow.

A good theory but no .... that's not what I'm seeing here. There's no yellow
in the scheme, and if I apply different schemes, it doesn't affect the pasted
excel data, whether one of the autoformatted ones or a normal one.

 

[Echo S]

A good theory but no .... that's not what I'm seeing here. There's no yellow
in the scheme, and if I apply different schemes, it doesn't affect the pasted
excel data, whether one of the autoformatted ones or a normal one.

Cool. Thanks for clarifying, because from here, it sure seemed like that's
what was happening!