Issue embedding an excel chart into Powerpoint

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcap74@gmail.com - 12 Nov 2006 18:34 GMT

Whenever I try to embed an excel chart into powerpoint, the format of
the chart is not retained. Specifically, a large space between the
edge of the chart area and the y-axis appears and the chart legend
moves. I have noticed that this only occurs, when I realign the y-axis
title so it is horizontal and place it at the top of the chart. I am
using Office XP at home but have seen this same issue with Office 2000.

I also noticed that this does not happen when I copy as either a link
or a picture. However, neither option is practical since others need
to access the data behind the slide.

This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message

Echo S - 12 Nov 2006 19:09 GMT

The problem is that the plot area is resizing to make up for the change in
the position of the Y-axis title.

Are you changing the position of the chart title in Excel before you place
the chart into PPT, or are you doing it once the chart is in PPT, and then
the plot area is resizing?

Also, how are you embedding the chart into PPT? Are you pasting it directly
on the slide, or are you pasting it in a content placeholder or are you
doing something else or what?

Signature

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/

> Whenever I try to embed an excel chart into powerpoint, the format of
> the chart is not retained. Specifically, a large space between the
[quoted text clipped - 8 lines]
>
> This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message

mcap74@gmail.com - 12 Nov 2006 22:20 GMT

Echo,

Thanks for the reply. To answer your questions:

(1) I am changing the position of the axis title in Excel, before I
copy it into Powerpoint
(2) I am using the copy and paste to embed the chart into Powerpoint

My charts are sized in Excel so that they shouldn't have to be rescaled
in Powerpoint. I have noticed that the embedded charts in Powerpoint
are ~ 15% smaller than the original Excel file. While I don't know if
this is a symptom of the problem or an unrelated issue, it seems to fit
with your explanation that the plot area is resizing.

> The problem is that the plot area is resizing to make up for the change in
> the position of the Y-axis title.
[quoted text clipped - 24 lines]
> >
> > This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message

Echo S - 12 Nov 2006 23:03 GMT

Hm. This is odd.

What if you right-click the chart, choose Format Object, and change the size
(on the size tab) to 100% x 100%?

Signature

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/

> Echo,
>
[quoted text clipped - 43 lines]
>> >
>> > This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message

mcap74@gmail.com - 13 Nov 2006 04:06 GMT

The chart size increases when resized to 100% but the issue with the
chart area remains. Any other ideas?

> Hm. This is odd.
>
[quoted text clipped - 53 lines]
> >> >
> >> > This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message

Echo S - 13 Nov 2006 14:59 GMT

Sorry, no. The only other thing I know is to fix it manually.

It's really strange, though.

Signature

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/

> The chart size increases when resized to 100% but the issue with the
> chart area remains. Any other ideas?
[quoted text clipped - 65 lines]
>> >> >
>> >> > This is driving me nuts!!!! Any help would be appreciated.

Reply to this Message