spot_img

Chart with non-numeric data

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.

 

data tableGo to Insert and click PivotChart button.ribbon pivot chartNew window pops out.pivot chart fieldsNow drag the respondents into values and drag response into legend.

drag pivot chart fields

Thus, you will get the chart on your sheet.

chart with non-numeric data

That’s how you can insert your char with non-numeric data. You may need it for example for illustrated surveys. That’s exactly how it is also named as yes no chart.

Template

You can download the Template here – Download
Further reading: 
How to define custom number format?
Combining Data from Multiple Sheets into one file
Chart with multiple series
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR