How do I graph text information in Excel

[Guest]

I'm trying to graph the results of a survey. The responses are either Yes,
No, or Not Applicable (N/A), and should be shown on the Y-axis (the Z-axis if
I go to a 3D graph). I have not yet been able to do this. Can anyone help?

 

[Barb Reinhardt]

Take a look at Jon Peltier's Vertical Category Axis instructions:

http://www.peltiertech.com/Excel/Charts/Y_CategoryAxis.html

I'm trying to graph the results of a survey. The responses are either Yes,
No, or Not Applicable (N/A), and should be shown on the Y-axis (the Z-axis if
I go to a 3D graph). I have not yet been able to do this. Can anyone

help?

 

[Jon Peltier]

If what you have is a list of Yes/No/NA responses, select the list and build a pivot
table, using the Pivot Table Report itom on the Data menu. Drag the Response field
into the Row area of the pivot tabel, then drag it again into the data area of the
pivot table, and you will get a list of the number of each response.

For this data, for example:

Response
No
NA
Yes
NA
No
Yes
NA
NA
NA
Yes
Yes
No

Create the pivot table, drag the response field button to the Row area, then drag it
to the data area, to produce this pivot table:

Count of Response
Response Total
NA 5
No 3
Yes 4
Grand Total 12


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

 

[Susan Lambert]

The easiest way I've found to do this is to sort the column (if all answers
are in the same column), then add up and post a number for the yes, no, N/A.
Then I post the answer column on the X-Axis. It's a work around but it
works ok for me where I do a lot of survey type graphs also.

 

[Jon Peltier]

Susan -

I don't see my original response, but I probably suggested a pivot table. The nice
thing about the pivot table is that it adds up the responses of each type for you,
without making you sort or count them or mistype the number yourself. Well, making
ME mistype the number; you might be one of those people who can type.

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