pie chart to reference certain cells in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how I can use the chart wizard and make a pie chart that will
give percentages of each of the choices in a column. There are 4-5 different
choices in the column. For excell 2000 or 2003. Thank you.
 
You can use a pivot table to count the number of responses in each category (the
field of responses is used in the row area and count of responses is used in the
data area). When you plot this in a pie chart, one of the label options is percentage.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top