pivot+table

[|Printable Instructions] 1) Make sure columns of data to be charted are next to each other. If not:
 * Creating a Pivot Table**
 * a. Right click on column header to be moved (letter label at top of column)
 * b. Cut
 * c. Right click on header at top of column to be replaced with cut column
 * d. Insert cut cells

2) Highlight data to be charted (NB, this is easier starting from the bottom of the data. 3) Data > Pivot Table and Pivot Chart Report 4) Pivot Chart report (with Pivot Table report) 5) Next 6) Finish 7) Drag data items to Drop Category Fields Here 8) Drag a data item to Drop Data Items Here 9) User normal chart wizard to:
 * a. Change to pie charts, etc. if required
 * b. title chart and label axes

c. create data labels, such as %s in a pie chart