1-866-245-5224 sales@keystonelearning.com

Excel 2003: Creating a PivotChart

Excel 2003: Creating a PivotChart

     
  1. Position your cursor on any cell within your list
     
  2.  
  3. Choose Data: PivotTable and PivotChart Report from the Menu bar
     

Figure 38. PivotTable and PivotChart Wizard Dialog Box – Step 1 of 3

   3.      Choose Microsoft Office Excel list or database

   4.      Choose PivotChart report (with PivotTable report) for the kind of report you want to create and then click Next

 

Figure 39. PivotTable and PivotChart Wizard Dialog Box – Step 2 of 3

   9.      Verify the range is correct and then click Next

Figure 40. PivotTable and PivotChart Wizard Dialog Box – Step 3 of 3

         10.    Choose the location of your PivotChart and then click FinishFigure 41. Designing a PivotChart

Figure 41. Designing a PivotChart

         10.  Drag the fields listed in the Field List onto the PivotChart at your preferred areas (Page, Series and Data)

         11. Once done, close the PivotTable Field List Dialog box