Excel to powerpoint problem

[sooncf]

Inside Excel chart I drawn some line (manually draw)
The purpose me doing this is to extend the X-axis and Y-axis
without resizing the chart.
Everything looks OK in Excel chart.
But After I put the excel chart into powerpoint
this line shift a little bit to other location.

Another occation is I drawn some fancy lagend
(with manually drawn line and manually key in text)
In excel they look OK. (in one row)
But after put into powerpoint,
the manually drawn line and text no more in one row.
The line look shifted a litte bit up-ward.

 

[pptuser]

Try the following:

1. Open the Draw toolbar in Excel (the one you use to draw
lines and shapes).
2. See if you can use the 'group' function for the Excel
chart and the extra lines, legends.
3. Save the file.
4. Now try to insert the Excel chart into PowerPoint
rather than copy it.

Alternately,
1. Use the Chart menu to modify the scale of the X and Y
axes, so they extend beyond your data.
2. Use the Chart menu to modify your legends, etc.
3. Copy or insert the edited chart into PowerPoint.

 

[John Langhans [MSFT]]

[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

To me, this sounds like a problem/limitation with how Excel creates the
rendering for its drawing objects when it updates it's OLE chart objects.

One of the first steps for troubleshooting OLE objects is to isolate
whether the problem is in the container (in this case, PowerPoint) or in
the server (in this case Excel).

To isolate the problem:
1) First try a different container applications. I usually recommend
WordPad since it's the most generic OLE container and it ships with Windows.
a) Insert same object into WordPad
b) If applicable, perform same operation on object (if possible) that you
performed in other container (such as resizing object)
c) Does the problem occur in both containers? - If so, the problem might
be with the source application or just an OLE limitation

2) Try different source applications: Which ones I recommend would depend
on the problem. However, it is not always possible to find another source
application which provides a rendering of it's object in the same way so
you might not be able to definitively determine whether it's a container
application problem (because it occurs with multiple source applications).
a) Insert different source object into the same container application (in
this case, PowerPoint)
b) If applicable, perform the same operation on this object that you
performed on the other object (such as resizing object)
c) Does the problem occur with this object? If not, repeat steps 2a-2c
with additional source applications.

So:
* If the problem occurs with only 1 source and multiple containers -> Most
likely a problem or limitation with source application
* If the problem occurs with only 1 container and multiple sources -> Most
likely a problem or limitation with container application
* If the problem occurs with multiple container and multiple sources ->
Most likely a limitation of OLE technology

As always, if you (or anyone else reading this message) have suggestions
about how PowerPoint and Office interoperability (such as Object Linking
and Embedding) should be improved, don't forget to send your feedback (in
YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions)


John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm