Thread: Excel Graphs: How do I graph words and other string data?

I have a list of words, one in each cell, such as Jimmy, Joe, Sam, Joe, Jimmy, Jimmy. I want to make a bar graph showing the frequency of each name. How can I do this? Can I only make graphs with number data?

The data from my example should yield Jimmy: 3, Joe: 2, Sam: 1, and create a graph illustrating such.

Also, is there a way to toggle case sensitivity?

Please don't ask me to count them by hand or to use a find/replace to count them. I have over 26,000 data and many unique entries.

Thanks!
Multi

I would use Excels Advanced Filter to copy unique names to another location, let's say starting in G1 and then next to each name use COUNTIF

Code:

=COUNTIF(Original Range,G1)

Then graph Columns G and H. Does that work for you?

Thanks. That does help, but I'm very new to this and I'm not sure how to use that feature.

How do you get a text list from the Advanced Filter?

In Excel 2007, from the Data Tab choose Advanced Filter. With Advanced Filter, you need to include the header (must have) in your range.Click on "Copy to another Location", set your range (e.g. A1:A2500), Check "Unique Records Only" Leave "Criteria Range" blank and in "Copy to" put the first cell of where you want your unique list (e.g. G1). Does that help?