in said:
Why or how do we do links of excel files (charts)in to ppt? You can do it in
Word, but I don't see the option in PPT.
Hi,
One way (Office 2004 and earlier)
With Excel open and the graph¹s data range in front of you, and with
PowerPoint open to a blank slide, in PowerPoint use Insert > Chart. A
default graph will open. Switch to Excel. Select the data range that is
being used for the graph in Excel. From Excel¹s menu choose Edit > Copy.
Switch to the open Microsoft Graph application. From Graph¹s menu choose
Edit > Paste Link. Format the graph as desired. Then Graph > Close and
Return to Presentation.
Another way (Office 2004 and earlier) - Similar to the above
With Excel open and the graph¹s data range in front of you, and with
PowerPoint open to a blank slide, in PowerPoint use Insert > Object >
Microsoft Excel WorkSheet. A blank Excel worksheet will appear and you will
be in Excel. Use the Excel Window menu to switch to the data you want
linked. Select the data range that is being used for the graph in Excel.
From Excel¹s menu choose Edit > Copy. From Excel¹s Window menu switch to the
worksheet from the Presentation. Use Edit > Paste Special and click the
Paste Link button From Graph¹s menu choose Edit > Paste Link. Create a
graph as desired and its location should be a graph sheet. Then Excel >
Close and Return to Presentation.
In both of the above cases the data and the resultant graph will be linked
to the original Excel worksheet¹s data.
If you are using Office 2008 let me know and I will try it there. It appears
some variation on the second method might work. My first attempt resulted
in lots of errors but it appears that it is due to a conflict between Office
2004 and Office 2008 residing on the same machine.
-Jim
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info
