custom color control for powerpoint graphs / excel color palattes

[Guest]

Is there anyway to share color palettes between Office applications?

I am designing a powerpoint presentation using numerous graphs sent to me
from the client. Each graph has been colored arbitrarily and I need to make
it correspond to the powerpoint color scheme. The problem is that when I try
and edit the graph within Powerpoint (using the "format data series" command)
I no longer have access to custom colors or the powerpoint color scheme.

A workaround is to edit the graph in Excel where custom colors can be
accessed but even there I have no access to the powerpoint color scheme. I
suppose I can keep resetting the custom colors for each graph but I have
dozens of graphs and it would be very time consuming.

Why isn't color control standardized across the office apps?

 

[Echo S]

It's much more standard in Office 2007 with the new themes, but in previous
versions, it's harder than it should be.

Anyway, if your color scheme in PPT is set up correctly, you should get at
least 4 data sets that match the slide color scheme. Here's some reading for
you about recoloring charts: http://www.echosvoice.com/charts.htm

In Excel, you can make one workbook with the appropriate color scheme /
color palette (use Tools | Options | Color | Modify). Save it, and leave it
open. Then open the Excel file with the existing chart and go to Tools |
Options | Color. In that dialog, there's a "copy colors from" option that
lists all open files in the dropdown. Since your color scheme file is open,
is should show up there. Just select it, and the color scheme / palette you
created will be available.

 

[Guest]

thankyou Echo S thats very helpful

It's much more standard in Office 2007 with the new themes, but in previous
versions, it's harder than it should be.

Anyway, if your color scheme in PPT is set up correctly, you should get at
least 4 data sets that match the slide color scheme. Here's some reading for
you about recoloring charts: http://www.echosvoice.com/charts.htm

In Excel, you can make one workbook with the appropriate color scheme /
color palette (use Tools | Options | Color | Modify). Save it, and leave it
open. Then open the Excel file with the existing chart and go to Tools |
Options | Color. In that dialog, there's a "copy colors from" option that
lists all open files in the dropdown. Since your color scheme file is open,
is should show up there. Just select it, and the color scheme / palette you
created will be available.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

Is there anyway to share color palettes between Office applications?

I am designing a powerpoint presentation using numerous graphs sent to me
from the client. Each graph has been colored arbitrarily and I need to
make
it correspond to the powerpoint color scheme. The problem is that when I
try
and edit the graph within Powerpoint (using the "format data series"
command)
I no longer have access to custom colors or the powerpoint color scheme.

A workaround is to edit the graph in Excel where custom colors can be
accessed but even there I have no access to the powerpoint color scheme. I
suppose I can keep resetting the custom colors for each graph but I have
dozens of graphs and it would be very time consuming.

Why isn't color control standardized across the office apps?