Recolor 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....

--
Echo [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


"Chrisp" wrote in message
...
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.

I tried using the same theme. The Excel data comes over in black text, which
does not show on dark background....

"Echo S" wrote:

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....

--
Echo [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


"Chrisp" wrote in message
...
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.

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....

--
Echo [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


"Chrisp" wrote in message
...
I tried using the same theme. The Excel data comes over in black text,
which
does not show on dark background....

"Echo S" wrote:

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....

--
Echo [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


"Chrisp" wrote in message
...
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.

In article , Chrisp wrote:
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, 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.

"Echo S" wrote:

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....

--
Echo [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


"Chrisp" wrote in message
...
I tried using the same theme. The Excel data comes over in black text,
which
does not show on dark background....

"Echo S" wrote:

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....

--
Echo [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


"Chrisp" wrote in message
...
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.

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.

"Steve Rindsberg" wrote:

In article , Chrisp wrote:
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
================================================

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....

--
Echo [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


"Chrisp" wrote in message
...
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.

"Steve Rindsberg" wrote:

In article , Chrisp
wrote:
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
================================================

In article , Echo S wrote:
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....

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
================================================

In article , Chrisp wrote:
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.

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
================================================