CS101 Assignment No.03 Fall 2013-2014 How to Insert an Excel worksheet or chart in a PowerPoint presentation

CS101 Assignment No.03 FALL 2013

How to Insert an Excel worksheet or chart in a PowerPoint presentation

Go to the Excel spreadsheet which has your data. 

Select the data you would like to chart, create a simple chart in your Excel sheet. 

Then copy the chart and paste it into your PowerPoint slide. 

You can now format the chart with all of PPT’s charting tools, and if you go to the Design Contextual Tab and select Edit Data, it will bring up your Excel spreadsheet. 

You can delete the chart you created in Excel, which will have no effect upon the PowerPoint Chart. The chart will be automatically linked to the Excel data. 

This may not be an elegant solution, but it is simple and it works. There is no command to indicate in PowerPoint which existing Excel spreadsheet you would like to use for your graph.

 In PowerPoint 2003, to use your Excel spreadsheet data to create a PowerPoint chart, you can:

• Copy your spreadsheet data into the datasheet PPT provides when you go into charting.
• Go into charting in PPT and use the Import File button on the chart toolbar to insert your Excel spreadsheet (you need to know the range of cells to import).
• Insert Object, From a File, in your PPT slide and browse to select your Excel file – indicate whether you wish to have it linked or not, and them Import the Excel data.