Sometimes you need to create a chart without numeric data. You just need a simple yes no chart in Excel. There is such a possibility. Just follow these steps.
Enter your non numeric data into Excel sheet and select it.
Go to Insert and click PivotChart button.
New window pops out.
Now drag the respondents into values and drag response into legend.
Thus, you will get the chart on your sheet.
That's how you can insert your char with non-numeric data. You may need it for example for ilustratic surveys. That's exacly how it is also named as yes no chart.
Further reading: How to define custom number format? Combining Data from Multiple Sheets into one file Chart with multiple series