Creating a chart with text not numbers

[Guest]

How do I create a chart that has text values (freshman, sophomore, junior,
senior) instead of numbers (1, 2, 3, 4)?

I have a column labeled "What is your class standing?" and below it is 166
rows where people selected "Freshman," "Sophomore," etc. I want to create a
bar chart that counts how many people selected each of the four classes.

Thanks,

Alan

 

[Jon Peltier]

First of all, you will have numbers to plot. The words are your category
labels.

Read how to turn a column of words like this into a histogram:

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon