Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

Inserting Charts 465


SET UP You need the WaterConsumption workbook and the WaterSavingC_start
presentation located in your Chapter16 practice file folder to complete this exercise.
From Windows Explorer, open the WaterConsumption workbook in Excel by double-
clicking the workbook’s file name. Then open the WaterSavingC_start presentation,
and save it as WaterSavingC. Ensure that the PowerPoint program window is
maximized, and then follow the steps.


  1. Display slide 7 , and then in the content placeholder, click the Insert Chart
    button.
    The Insert Chart dialog box opens.


You can choose from many types of charts in this dialog box.


  1. With Column selected in the left pane, click the first thumbnail in the second row
    (Clustered Cylinder), and then click OK.
    PowerPoint inserts the chart into the slide and resizes its program window to
    occupy the left half of your screen. Excel starts and displays the data used to plot
    the chart in the right half of the screen.

  2. From the Windows Taskbar, display the WaterConsumption worksheet. Then in
    the worksheet, point to cell A3, and drag down and to the right to cell C13.
    Excel selects all the cells in the range A3:C13.

Free download pdf