 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / April 2008Recolor Excel Data in PPT 2007
I need to link data from Excel into PowerPoint...I know Paste Link. Here are the challenges: The PowerPoint slide has a dark background and I need white text and I need to be able to print it in pure black & white. Anythink entered directly into PowerPoint that is white text prints fine in pure black & white, the paste links (that I changed to white in Excel) will not print. Cannot figure out how to change the color in PowerPoint on the linked object. PS This is the CEO's Presentation and so you know the rest of the story. Only thing I know to suggest here is to use PPT 2003 where you can recolor as described in #1 at http://www.echosvoice.com/charts.htm. Alternatively, apply the same theme to the Excel 2007 file as is used in the PPT 2007 file. That *should* supply appropriate colors....  SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://tinyurl.com/36grcd PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx >I need to link data from Excel into PowerPoint...I know Paste Link. Here >are [quoted text clipped - 12 lines] > > PS This is the CEO's Presentation and so you know the rest of the story. I tried using the same theme. The Excel data comes over in black text, which does not show on dark background.... > Only thing I know to suggest here is to use PPT 2003 where you can recolor > as described in #1 at http://www.echosvoice.com/charts.htm. [quoted text clipped - 18 lines] > > > > PS This is the CEO's Presentation and so you know the rest of the story. What if you go to Chart Tools Design in Excel and choose one of the options there with a dark background (in the Chart Styles gallery). It should give you light text automatically. Then when you copy and Paste Special into PPT, you should get that dark background and light text. It works in a quick test here.... SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://tinyurl.com/36grcd PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx >I tried using the same theme. The Excel data comes over in black text, >which [quoted text clipped - 28 lines] >> > PS This is the CEO's Presentation and so you know the rest of the >> > story. Yes, that does work, but I don't need a chart. I am linking to cell data only. It's a large quantity of financial data that is then updated every month. With the links, they only update the data in the Excel file and the PowerPoint is automatically up-to-date. > What if you go to Chart Tools Design in Excel and choose one of the options > there with a dark background (in the Chart Styles gallery). It should give [quoted text clipped - 34 lines] > >> > PS This is the CEO's Presentation and so you know the rest of the > >> > story. > I tried using the same theme. The Excel data comes over in black text, which > does not show on dark background.... This worked in a quick test: Copy/Paste and link the data from one worksheet in Excel to another. On the new linked copy, format the text to the color you need it in PPT. NOW copy/paste/link it into PPT. The only oddity I notice is that the link to the link produces zeros in blank cells in PPT. Might have to do a bit of extra formatting in Excel to stop that silliness. With luck they'll finish PPT 2007 one of these days and make the B/W View properies work for paste/linked Excel stuff again. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Yes, that does work for the visual part of it. The heart of the problem here is printing it in Pure Black & White. When you make the Excel data white in Excel and then paste link it to PowerPoint and print it in pure black & white, you get a white background with white text. In 2003, they would recolor it and change it to Inverse, but that feature is no longer in PowerPoint. Do you have some sort of info that this may be rectified in PowerPoint 2007 or just wishful thinking? We took it all the way to Pay for Support with Microsoft and they agreed it does not work, but would not say if it was a "bug" or if it would be fixed/changed in the future. > > I tried using the same theme. The Excel data comes over in black text, which > > does not show on dark background.... [quoted text clipped - 17 lines] > PPTools: www.pptools.com > ================================================ Oh, yeah, the B/W printing options ... apparently the "hooks" from Excel aren't available for PPT to use for B/W printing (or something like that). At least that's the case with charts, and I assume probably the same for the worksheets. I don't know if they plan to fix this in Office 14 or not -- it's definitely annoying. It's as though Microsoft thinks nobody prints in black and white anymore.... SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://tinyurl.com/36grcd PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx > Yes, that does work for the visual part of it. The heart of the problem > here [quoted text clipped - 37 lines] >> PPTools: www.pptools.com >> ================================================ > Oh, yeah, the B/W printing options ... apparently the "hooks" from Excel > aren't available for PPT to use for B/W printing (or something like that). [quoted text clipped - 4 lines] > annoying. It's as though Microsoft thinks nobody prints in black and white > anymore.... Same deal with Worksheets. Add it to the Office Art Big and Growing List o' PowerPainPoints? ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ > Yes, that does work for the visual part of it. The heart of the problem here > is printing it in Pure Black & White. When you make the Excel data white in [quoted text clipped - 3 lines] > In 2003, they would recolor it and change it to Inverse, but that feature is > no longer in PowerPoint. Yep, both Recolor and the other dodge, B/W settings for the Excel object, are both gone. This has been reported, but whether it'll get attention or not, I've no way of knowing. The lack of it can really make bulletsized holes in a lot of toes. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
Reply to this Message |
 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.