Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / November 2005

Tip: Looking for answers? Try searching our database.

Colors different when move Excel to Powerpoint?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Al Franz - 11 Nov 2005 00:36 GMT
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 - 11 Nov 2005 01:04 GMT
> 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?

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
Al Franz - 11 Nov 2005 01:23 GMT
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.

>> Using the latest version of Microsoft office tools.  I cut and copy a
>> chart
[quoted text clipped - 17 lines]
> PPTools:  www.pptools.com
> ================================================
Echo S - 11 Nov 2005 03:43 GMT
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

Signature

Echo [MS PPT MVP]
http://www.echosvoice.com

> Ungrouping had no effect.  Dark Red/Brown color I have in my spreadsheet
> converts to Powerpoint accurately.  The light yellow/beige converts to a
[quoted text clipped - 21 lines]
> > PPTools:  www.pptools.com
> > ================================================
Steve Rindsberg - 11 Nov 2005 15:59 GMT
> 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?

> >> Using the latest version of Microsoft office tools.  I cut and copy a
> >> chart
[quoted text clipped - 17 lines]
> > PPTools:  www.pptools.com
> > ================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
Al Franz - 11 Nov 2005 20:56 GMT
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.

>> Ungrouping had no effect.  Dark Red/Brown color I have in my spreadsheet
>> converts to Powerpoint accurately.  The light yellow/beige converts to a
[quoted text clipped - 33 lines]
> PPTools:  www.pptools.com
> ================================================
Echo S - 12 Nov 2005 01:44 GMT
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.

Signature

Echo [MS PPT MVP]
http://www.echosvoice.com

> Using the latest release of Excel 2003.  Select Format/AutoFormat then
> select "Colorful 2".  If you import that yellow color into Powerpoint I
[quoted text clipped - 39 lines]
> > PPTools:  www.pptools.com
> > ================================================
Steve Rindsberg - 12 Nov 2005 04:06 GMT
> 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.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
Echo S - 12 Nov 2005 13:47 GMT
> > 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
[quoted text clipped - 3 lines]
> 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!

Signature

Echo [MS PPT MVP]
http://www.echosvoice.com

Steve Rindsberg - 12 Nov 2005 04:06 GMT
> 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.

> >> Ungrouping had no effect.  Dark Red/Brown color I have in my spreadsheet
> >> converts to Powerpoint accurately.  The light yellow/beige converts to a
[quoted text clipped - 33 lines]
> > PPTools:  www.pptools.com
> > ================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
Al Franz - 11 Nov 2005 01:51 GMT
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.

>> Using the latest version of Microsoft office tools.  I cut and copy a
>> chart
[quoted text clipped - 17 lines]
> PPTools:  www.pptools.com
> ================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.