Tuesday, January 16, 2007

From an Excellent to a Powerful Word

Oops, I forgot to update my blog yesterday. So here's what had happened so far:

I just went to the Papillion Restaurant in downtown Toronto as a French trip. It was fun, and the food was pretty good.

Yesterday, we learned how to insert a graph from Microsoft Excel to Powerpoint or Word without breaking the link between the graph and its table or data. Simply follow these steps:

1) highlight your table and create your chart
2) before you finish click on 'As New Sheet'
3) this would make your chart on a new sheet
4) save this graph
5) open up your document in Powerpoint or Word
6) click on Insert, Object, click on the tab 'Create From File',
7) click on Browse and look for the graph you saved
8) click on 'Link to File' and a check mark should appear on the box
9) click OK
10) your graph should appear on your document

This way is better than just copying or pasting your graph because every time you need to edit your data in Excel, your graph would be linked to it. It would change the information automatically, and you wouldn't have to make a new graph.

0 Comments:

Post a Comment

<< Home