Jon,

I am following the advice given but my pivot table keeps defining 'Yes' or
'No' as a value of 1. So when it's listing whether employee no. x used a, b
or c it counts 'yes' and 'no' as '1' each so even when employee only used a
and not b or c it still classes them both as a positive (1) and so my totals
are coming out '3' everytime because there are 3 options, even when I have
only put 'Yes' for 1 option. What am I doing wrong?

Gina
"Jon Peltier" wrote:

Doug -

Take the survey data, laid out like this:

color fruit
1 red apple
2 green orange
3 red orange
4 green banana
5 blue apple
6 red grapes
7 green apple
8 red orange
9 green orange
10 blue banana

and rearrange it like this:

item value
1 color red
2 color green
3 color red
4 color green
5 color blue
6 color red
7 color green
8 color red
9 color green
10 color blue
1 fruit apple
2 fruit orange
3 fruit orange
4 fruit banana
5 fruit apple
6 fruit grapes
7 fruit apple
8 fruit orange
9 fruit orange
10 fruit banana

Make a pivot table, putting item and value in the Rows area and Count of value in
the Data area:

Count of value
item value Total
color blue 2
green 4
red 4
fruit apple 3
banana 2
grapes 1
orange 4

One pivot table contains all the data. You need to make a non-pivot chart to graph
only some of this data, select a blank cell not touching the pivot table, start the
chart wizard. Step 1, select a pie chart. Step 2, click on the Series tab, then
click Add, and for categories select the range of colors and for values select the
totals next to the colors. There's your first chart. Make a copy of the chart, click
on the pie, and drag and resize the purple and blue highlight rectangles to change
from the colors to the fruits.

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


Doug VanOrnum wrote:

Thanks Jon -- a clarification: One analogy would be a column of "favorite
colors". Maybe there are six colors to choose from. A "pivot table" would
count the number of instances of "orange", for example, as well as the other
colors? Then I could make a pie chart of the pivot table?

Hmmm...so that means if my questionnaire has 45 questions total, I'd have to
set up a separate pivot table for each question, then make a chart or graph
for each...sounds pretty inefficient. Is there a better path I need to take
to get to the desired end-result?

"Jon Peltier" wrote:


So you have a column of Yes/No or P/K or J/N? Construct a pivot table of this range,
and you can produce counts of each value. Then make a chart of these counts.

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

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?