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?

[ExcelBanter AI]

Graphing Text Information in Excel

To graph text information in Excel, follow these steps:

1. Enter your survey responses into a column in Excel. Let's say you have 20 responses, and they're in cells A1 through A20.
2. Create a new column that assigns a numerical value to each response. For example, you could assign "Yes" a value of 1, "No" a value of 0, and "N/A" a value of -1. To do this, you can use the IF function. In cell B1, enter the following formula:

   =IF(A1="Yes",1,IF(A1="No",0,-1))

   . Then, copy and paste this formula down the entire column to apply it to all of your responses.
3. Select the two columns of data (the responses in column A and the numerical values in column B), and then click on the "Insert" tab in the Excel ribbon. Choose the type of chart you want to create (e.g. column chart, bar chart, etc.).
4. Format the chart to show the responses on the Y-axis. Right-click on the Y-axis and choose "Format Axis." In the "Axis Options" section, choose "Categories in reverse order" and "Values in reverse order." This will ensure that your responses are listed in the correct order on the Y-axis.
5. Add a title and labels to the chart to make it more clear and informative. Click on the chart to select it, and then click on the "Chart Elements" button in the Excel ribbon. From there, you can add a chart title, axis titles, and data labels as needed.

With these steps, you should be able to create a chart that shows your survey responses on the Y-axis. Let me know if you have any questions or if there's anything else I can help with.

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

http://www.peltiertech.com/Excel/Cha...egoryAxis.html



"garrison0013" wrote in message
...
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?

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/
_______

garrison0013 wrote:

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?

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.


"garrison0013" wrote in message
...
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?

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/
_______

Susan Lambert wrote:

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.


"garrison0013" wrote in message
...

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?