Excel Chart of Non-Numeric Data?

Question

I have a spreadsheet that has some non-numeric data I'd like to chart. The spreadsheet is from an online web form I'm doing statistical analysis of. For example, I have a field that is gender, "Male" and "Female" - I'd like to have a pie chart that shows the breakdown as a whole (60% Male and 40% Female and 10% Not Sure). Is this possible in Excel. I also have Access, if it has better reporting tools.

Answer 1

You have to give numeric values to create a chart.



Using the "COUNTIF" command you can get their totals easily.

Eg :- =COUNTIF(range,"male"), COUNTIF(range,"female"),



Using those 2 formula, you can create the chart.

Answer 2

you are able to no longer plot factors vs factors - this is not significant, as factors have no order to them. Create an extra column alongside your documents with the grades substituted for numbers (eg backside grade a million, next grade up 2, and so forth) and plot those against your LBN, LBL, and so forth - you are able to edit the axis labels to coach the non-numeric grades somewhat than the numbers which you somewhat plotted

Answer 3

yes .. its possible... n the interface is also quite easy... (use the wizard)... n if anything gets messd up.. use the inbuilt help...



just create the table then select the fields to plot on click on the graphs n charts button on the top...