Excel graph embedding into PPT XP SP-2

[Smitty]

I am trying to bring in an Excel Graph (scatter-plot, auto-labeled by PUP)
and embed it into PPT. It seems to come in fine, but if you double-click on
it to launch it, make changes, and then click back out in PPT, the graph
skews out of proportion. (font's get funky - wide) Not all the time with
all graphs, but sooner or later they all seem to be doing it. HELP!!!!

Windows XP, Office XP SP-2

 

[Echo S]

These suggestions may help:
http://www.echosvoice.com/charts.htm

Also see if right-clicking and choosing Edit or Open works better for you.

Finally, are you using a wide screen?

 

[Smitty]

The suggested article only deals with Graph inside of PPT. I'm dealing with
Graph inside Excel, then embedded (the worksheet itself is embedded) inside
PPT. So when you double-click/rt-click,OPEN to open up the graph, you are
actually view an embedded excel object. And it's that object that's going
wacko. In fact in a few tests we found:

The original size (evidenced by Format Object|Original Size) starts out as
one dimension [say 4x5], but as soon as you open the graphic, it wacks out,
you close it, it displays a different original size [3.76x5.14]. Now,
nothing has changed with our original graphic, and this will continue
changing on it's own every time it screws up. We can hit reset, and it'll
reset itself based on who knows what. And it screws up regardless of if we
accept the default paste size, or stretch it (proportionally of course) to a
different size.

Any other ideas? Thanks!

These suggestions may help:
http://www.echosvoice.com/charts.htm

Also see if right-clicking and choosing Edit or Open works better for you.

Finally, are you using a wide screen?

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

I am trying to bring in an Excel Graph (scatter-plot, auto-labeled by PUP)
and embed it into PPT. It seems to come in fine, but if you double-click on
it to launch it, make changes, and then click back out in PPT, the graph
skews out of proportion. (font's get funky - wide) Not all the time with
all graphs, but sooner or later they all seem to be doing it. HELP!!!!

Windows XP, Office XP SP-2

 

[Echo S]

Yes, I understand that you're dealing with an embedded Excel chart. The
stuff on the page I suggested applies to your situation as well. Sometimes
right-clicking and opening the embedded Excel object (worksheet/chart) helps
keep it from going berserk.

Also, if you put your charts on their own chart sheets in Excel, the size
doesn't whack out as much. I had to rebuild some Excel charts (embedded in a
PPT file) recently -- they were displaying the same kind of problems you
describe here, and nothing I did would make them look the way I wanted.
These charts were not on their own chart sheets, and I suspect that was a
big part of the problem.

Are you using a wide-screen?

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

The suggested article only deals with Graph inside of PPT. I'm dealing with
Graph inside Excel, then embedded (the worksheet itself is embedded) inside
PPT. So when you double-click/rt-click,OPEN to open up the graph, you are
actually view an embedded excel object. And it's that object that's going
wacko. In fact in a few tests we found:

The original size (evidenced by Format Object|Original Size) starts out as
one dimension [say 4x5], but as soon as you open the graphic, it wacks out,
you close it, it displays a different original size [3.76x5.14]. Now,
nothing has changed with our original graphic, and this will continue
changing on it's own every time it screws up. We can hit reset, and it'll
reset itself based on who knows what. And it screws up regardless of if we
accept the default paste size, or stretch it (proportionally of course) to a
different size.

Any other ideas? Thanks!

These suggestions may help:
http://www.echosvoice.com/charts.htm

Also see if right-clicking and choosing Edit or Open works better for you.

Finally, are you using a wide screen?

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

I am trying to bring in an Excel Graph (scatter-plot, auto-labeled by PUP)
and embed it into PPT. It seems to come in fine, but if you

double-click
on

it to launch it, make changes, and then click back out in PPT, the graph
skews out of proportion. (font's get funky - wide) Not all the time with
all graphs, but sooner or later they all seem to be doing it. HELP!!!!

Windows XP, Office XP SP-2

 

[Smitty]

No to the widescreen. (sorry I forgot to include that last time)

We tried some tests with the graph on it's own sheet, and it still wacked
out. I thought I had hit on a "perfect" solution by putting it on it's own
sheet, and then going through the Insert Object|From File, method, but even
that was *sometimes* unhappy. Why or why won't Excel and PPT play nice
together??

Thanks!

Yes, I understand that you're dealing with an embedded Excel chart. The
stuff on the page I suggested applies to your situation as well. Sometimes
right-clicking and opening the embedded Excel object (worksheet/chart) helps
keep it from going berserk.

Also, if you put your charts on their own chart sheets in Excel, the size
doesn't whack out as much. I had to rebuild some Excel charts (embedded in a
PPT file) recently -- they were displaying the same kind of problems you
describe here, and nothing I did would make them look the way I wanted.
These charts were not on their own chart sheets, and I suspect that was a
big part of the problem.

Are you using a wide-screen?

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

The suggested article only deals with Graph inside of PPT. I'm dealing with
Graph inside Excel, then embedded (the worksheet itself is embedded) inside
PPT. So when you double-click/rt-click,OPEN to open up the graph, you are
actually view an embedded excel object. And it's that object that's going
wacko. In fact in a few tests we found:

The original size (evidenced by Format Object|Original Size) starts out as
one dimension [say 4x5], but as soon as you open the graphic, it wacks out,
you close it, it displays a different original size [3.76x5.14]. Now,
nothing has changed with our original graphic, and this will continue
changing on it's own every time it screws up. We can hit reset, and it'll
reset itself based on who knows what. And it screws up regardless of if we
accept the default paste size, or stretch it (proportionally of course) to a
different size.

Any other ideas? Thanks!

These suggestions may help:
http://www.echosvoice.com/charts.htm

Also see if right-clicking and choosing Edit or Open works better for you.

Finally, are you using a wide screen?

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


I am trying to bring in an Excel Graph (scatter-plot, auto-labeled by PUP)
and embed it into PPT. It seems to come in fine, but if you double-click
on
it to launch it, make changes, and then click back out in PPT, the graph
skews out of proportion. (font's get funky - wide) Not all the time with
all graphs, but sooner or later they all seem to be doing it. HELP!!!!

Windows XP, Office XP SP-2

 

[Echo S]

No to the widescreen. (sorry I forgot to include that last time)

We tried some tests with the graph on it's own sheet, and it still wacked
out. I thought I had hit on a "perfect" solution by putting it on it's own
sheet, and then going through the Insert Object|From File, method, but even
that was *sometimes* unhappy. Why or why won't Excel and PPT play nice
together??

Wish I knew. OLE is whacky sometimes.

What I'd do is what Brian usually suggests -- put the chart on its own chart
sheet, scale to 100%. Select the chart, Ctrl+C to copy, then in PPT, hit
Ctrl+V. The default is to include the entire worksheet. You can also use
Edit|Paste Special and choose Excel object.

I *think* that's what Brian usually suggests, anyway. If it's not, he'll
come along and clarify, I'm sure.

Oh, wait. http://www.rdpslides.com/pptfaq/FAQ00067.htm He's talking about
linked charts, and he uses a custom chart sheet. Nuts. Might be worth a try,
though.