Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Insert ->PivotChart Pivot Chart Most people do not read numbers well. However, they can read a graph and compare the information. A PivotChart offers the same flexibility to manipulate the data as a PivotTable.   9. Create a PivotChart Go to the OriginalData spreadsheet and Select all.   Go to Insert->Pivot Chart.   You will be asked to confirm the location of the data and whether you would like to place the new PivotChart in a new spreadsheet.