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:
   Code:

   =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.