I have a list of text values (state abbreviations) and I need to generate a big pie chart that takes the number of occurrences of a state abbr, and slot that into a portion of the pie chart if that makes sense.



For example, if I had these values in a column:

CA
CA
CA
NY
NY
TX

So then my pie chart would 1. figure out how many different values there are (three) and 2. build a pie chart that had 1/2 CA, 2/3 NY and 1/6 TX.

Is it possible to do this? (My actual spreadsheet has over 1000 rows)