Plotting the frequency of a word (no-numerical data)

Originally Posted by nbn22385

I was wondering how i can make a plot of the frequency of certain words. For example, if I have a list of business locations all over the country, i can see a plot of the quantity of locations in each state. Assume I have a business name and a state column.

My data would look like this:
...
Business A | Florida
Business B | Florida
Business C | Florida
Business D | Florida
Business Z | Texas
...

I would want a bar graph like this:

Florida: XXXX
Texas: X

Thanks in advance.

Hi,

one method, using two columns (Say E and F)

Set autoFilter (Data, Filter, Autofilter) and then select the column with the states and Data, Filter, Advanced Filter, select Unique Records only, and copy to E2

In F2 put

=COUNTIF(B:B,E2)

and select E2:F~~ for your chart.

Also you can re-arrange column E after the unique selection has been made.

hth
---

Originally Posted by nbn22385

Thank you Bryan, that was exactly what I was looking for.

good to see, and thanks for your response.

---