The data field displays numbers. However, you can use non-numeric columns to
generate those numbers.
Start with a list of labels in A2:A20, and a header ("Labels") in A1. Create
a pivot table from the data in A1:A20. Drag the Labels field to the Rows
area and to the Data area. You will end up with a pivot table with a list of
unique labels in the Rows area, and a count of each label in the Data area.
See this short tutorial for an illustrated example:
http://peltiertech.com/Excel/ChartsH...idateData.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"sonal patel" wrote in message
...
Dear All
My question is somewhat same like Mr.Doug
I want to place non-numeric data in data field of Pivot Table..i.e name
Is it possible?
"Doug VanOrnum" wrote:
I would like to chart and graph responses to a survey that are
non-numeric in
nature, such as a bar graph for "yes" and no" responses to a question. Or
in
particular a pie chart that shows how many people picked option "P" vs.
"K",
"J" or "N". For the pie chart I have a column of data cells, each
containing
one of the four letters.
In short, how do I accomplish charting and/or graphing non-numeric
responses?