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

Chapter 26. Using Programs Together > Combining Excel and PowerPoint

Combining Excel and PowerPoint

Excel and PowerPoint can share information, too. You can copy and paste material from either application into the other. You can also import Excel files into a PowerPoint presentation.

To create a PowerPoint chart from imported Excel data

1.
Create a chart slide in PowerPoint and double-click the “Double click to add chart” placeholder (Figure 26.21).

Figure 26.21. Create a chart slide in PowerPoint and double-click the chart placeholder to launch Graph.


Graph launches (Figure 26.22).

Figure 26.22. Graph opens, displaying sample data and a temporary chart.


2.
If you want the imported data to begin in any cell other than the upper-left corner of the datasheet, click to select the starting cell.

3.
Choose File > Import File.

The Choose a File dialog box appears.

4.
Select the Excel file to import and click Choose.

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

Figure 26.23. Select a sheet to import. By clicking a radio button, you can import the entire sheet or only a specific range.


5.
Select the sheet to import, specify the range (if you want to import only part of the worksheet), and click OK.

6.
Edit and rearrange the data as necessary.

7.
Select a chart type from the Chart Type drop-down palette on the toolbar or choose Chart > Chart Type.

8.
Format the chart elements as desired. When the chart is satisfactory, choose Graph > Quit & Return to presentation name.

The finished chart appears on the slide (Figure 26.24).

Figure 26.24. Quit Graph. The finished chart appears on the PowerPoint slide. If you later need to alter the chart, double-click it on the slide.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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