• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Using Programs Together > Using Excel and PowerPoint

Using Excel and PowerPoint

Excel and PowerPoint share information as well. You can copy and paste information from one application to another. You can also take files you've already created in Excel and import them into your PowerPoint presentation.

To import Excel data to a PowerPoint chart:

1.
In PowerPoint, create a chart slide (Figure 30.21).

Figure 30.21. Create a chart slide in PowerPoint.


2.
Double-click the "Double click to add chart" placeholder.

The Microsoft Graph datasheet appears.

3.
Click the cell on the datasheet at the upper-left corner of the range of cells into which you want to import data from Excel (Figure 30.22).

Figure 30.22. Select the cell in the upper-left corner of the range into which you want to import data from Excel.


4.
Select Edit > Import File.

The Open dialog box appears (Figure 30.23).

Figure 30.23. In the Open dialog box, select the Excel file that you want to add.


5.
Select the Excel file that you want to add, and click Open.

The Import Data Options dialog box appears (Figure 30.24).

Figure 30.24. In the Import Data Options dialog box, select which sheet or chart to import.


6.
In the Import Data Options dialog box, select which sheet or chart to import, specify the range if you want to import only part of a worksheet, and then click OK.

7.
The Excel data appears in the PowerPoint graph (Figure 30.25).

Figure 30.25. The Excel data appears in the PowerPoint graph.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint