Powerpoint Graphs - Default Excel Colour Palette

[Karen Marley]

When ever I import an excel chart into a powerpoint chart
object, the colours change and have to be recoloured
manually.

What would be useful is, when importing the data/chart
from an Excel Sheet, the default colour scheme was as my
powerpoint template.

Can anyone help?

 

[Echo S]

Which version of Excel/PPT, and how are you importing the chart?

 

[Karen Marley]

Hi

We are using Office 2000 and importing the chart as
follows:

Open MS Graph object in ppt
Edit Menu Import File
Search for File
Select Chart

-----Original Message-----
Which version of Excel/PPT, and how are you importing the chart?

--
Echo [MS PPT MVP]

When ever I import an excel chart into a powerpoint chart
object, the colours change and have to be recoloured
manually.

What would be useful is, when importing the data/chart
from an Excel Sheet, the default colour scheme was as my
powerpoint template.

Can anyone help?

.

 

[Echo S]

I think that import sequence may be the issue, although it seems to work
fine here. Of course, if the chart in Excel isn't on its own chart
sheet, you're really just importing the Excel data when you do that. And
that means that the chart is really being created via MS Graph in PPT,
which is why it's picking up your slide color scheme colors instead of
maintaining your Excel chart colors.

Since you've already done the work in Excel, try this: Open the Excel
object and copying the chart, then in PPT go to Edit/Paste Special.
Choose Excel Chart Object. Note that this really embeds your whole Excel
worksheet, so when you double-click in PPT, it will open the Excel file.
You will need to make any subsequent changes to the chart by opening it
from within PPT -- if you change the chart in the Excel file, those
changes won't be reflected in PPT. This may also increase the size of
your file.

If you really just need an image of the chart and don't need to be able
to edit it, then choose Picture or Picture (Enhanced Metafile) when you
Paste Special in PPT.

You're not reapplying the slide layout or anything after you insert the
charts, are you? That could cause the color issues you're seeing, but
I'm not sure what's going on with just importing a chart sheet the way
you describe.

You can also make a color scheme in Excel which matches your slide color
scheme, if that's what you're after.

If I've totally missed the boat here, you'll have to holler back!

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

Hi

We are using Office 2000 and importing the chart as
follows:

Open MS Graph object in ppt
Edit Menu Import File
Search for File
Select Chart

-----Original Message-----
Which version of Excel/PPT, and how are you importing the chart?

--
Echo [MS PPT MVP]

When ever I import an excel chart into a powerpoint chart
object, the colours change and have to be recoloured
manually.

What would be useful is, when importing the data/chart
from an Excel Sheet, the default colour scheme was as my
powerpoint template.

Can anyone help?

.

 

[Guest]

The problem seems to be the colour scheme.
When importing the Excel Chart obect - it takes on the
excel default colour pallette. I have changed the default
colour palette to that of my ppt in the xlstart menu but
doesn't seem to make a different!

What would be ideal is for the default excel palette to be
changed to that of the colour scheme of my ppt
presentation.... Thus when I import the colours will be
correct.

-----Original Message-----
I think that import sequence may be the issue, although it seems to work
fine here. Of course, if the chart in Excel isn't on its own chart
sheet, you're really just importing the Excel data when you do that. And
that means that the chart is really being created via MS Graph in PPT,
which is why it's picking up your slide color scheme colors instead of
maintaining your Excel chart colors.

Since you've already done the work in Excel, try this: Open the Excel
object and copying the chart, then in PPT go to Edit/Paste Special.
Choose Excel Chart Object. Note that this really embeds your whole Excel
worksheet, so when you double-click in PPT, it will open the Excel file.
You will need to make any subsequent changes to the chart by opening it
from within PPT -- if you change the chart in the Excel file, those
changes won't be reflected in PPT. This may also increase the size of
your file.

If you really just need an image of the chart and don't need to be able
to edit it, then choose Picture or Picture (Enhanced Metafile) when you
Paste Special in PPT.

You're not reapplying the slide layout or anything after you insert the
charts, are you? That could cause the color issues you're seeing, but
I'm not sure what's going on with just importing a chart sheet the way
you describe.

You can also make a color scheme in Excel which matches your slide color
scheme, if that's what you're after.

If I've totally missed the boat here, you'll have to holler back!

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

Hi

We are using Office 2000 and importing the chart as
follows:

Open MS Graph object in ppt
Edit Menu Import File
Search for File
Select Chart

-----Original Message-----
Which version of Excel/PPT, and how are you importing

the
chart?

--
Echo [MS PPT MVP]

When ever I import an excel chart into a powerpoint chart
object, the colours change and have to be recoloured
manually.

What would be useful is, when importing the data/chart
from an Excel Sheet, the default colour scheme was as my
powerpoint template.

Can anyone help?



.

.

 

[Echo S]

Ok, so I guess I had it backwards from what you really want.

Create a graph in Excel and color it the way you want by modifying the
colors listed in the 8 "chart fills" boxes (using Tools/Options/Color). Save
that file.

Then open your "real" file and also reopen that file you made with the
correct colors. In the "real" file, go to Tools/Options/Color. In the box
for "copy colors from," choose the sheet you created with the correct
colors.

FWIW, though, when I import Excel data in the way you described below (Open
MS Graph object in ppt, Edit Menu Import File, Search for File, Select
Chart), my chart is actually created in PPT, which means it takes on the PPT
color scheme. If I import an Excel chart using Copy/Paste Special the way I
described below, the chart remains with the Excel color palette. I'm not
quite sure why it's not working that way on your end.

--
Echo [MS PPT MVP]

The problem seems to be the colour scheme.
When importing the Excel Chart obect - it takes on the
excel default colour pallette. I have changed the default
colour palette to that of my ppt in the xlstart menu but
doesn't seem to make a different!

What would be ideal is for the default excel palette to be
changed to that of the colour scheme of my ppt
presentation.... Thus when I import the colours will be
correct.

-----Original Message-----
I think that import sequence may be the issue, although it seems to work
fine here. Of course, if the chart in Excel isn't on its own chart
sheet, you're really just importing the Excel data when you do that. And
that means that the chart is really being created via MS Graph in PPT,
which is why it's picking up your slide color scheme colors instead of
maintaining your Excel chart colors.

Since you've already done the work in Excel, try this: Open the Excel
object and copying the chart, then in PPT go to Edit/Paste Special.
Choose Excel Chart Object. Note that this really embeds your whole Excel
worksheet, so when you double-click in PPT, it will open the Excel file.
You will need to make any subsequent changes to the chart by opening it
from within PPT -- if you change the chart in the Excel file, those
changes won't be reflected in PPT. This may also increase the size of
your file.

If you really just need an image of the chart and don't need to be able
to edit it, then choose Picture or Picture (Enhanced Metafile) when you
Paste Special in PPT.

You're not reapplying the slide layout or anything after you insert the
charts, are you? That could cause the color issues you're seeing, but
I'm not sure what's going on with just importing a chart sheet the way
you describe.

You can also make a color scheme in Excel which matches your slide color
scheme, if that's what you're after.

If I've totally missed the boat here, you'll have to holler back!

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

Hi

We are using Office 2000 and importing the chart as
follows:

Open MS Graph object in ppt
Edit Menu Import File
Search for File
Select Chart

-----Original Message-----
Which version of Excel/PPT, and how are you importing the
chart?

--
Echo [MS PPT MVP]

"Karen Marley" <[email protected]>
wrote in message
When ever I import an excel chart into a powerpoint
chart
object, the colours change and have to be recoloured
manually.

What would be useful is, when importing the data/chart
from an Excel Sheet, the default colour scheme was as my
powerpoint template.

Can anyone help?



.

.