Thread: [Solved] Generate chart from list of text values
View Single Post
 
Old 01-20-2011, 03:58 PM
knownunknown knownunknown is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Jan 2011
Location: London
Posts: 4
knownunknown is on a distinguished road
Default Generate chart from list of text values
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)
Reply With Quote