Saturday, January 11, 2014

yogi_From Entries Of Town In Column A Compute Number Of Instances of Each Town And Chart It

                                          Google Spreadsheet   Post  #1482
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-10-2014
question by Yeeputt (http://productforums.google.com/forum/?zx=qq552mtii8o4&usp=sheets_web#!category-topic/docs/spreadsheets/LAcJH_dNajU)
Creating a chart using only a single data source (one column in a sheet)
I’m trying to do a chart that is based on only one column of information in a sheet, which is entered using a drop down box. 
So, say, for example, I was collecting information on a group of students and one column related to where they lived, and the other columns were irrelevant. 
The might look column something like this:
Residence Location of Student
Town A
Town B
Town C
Town A
Town A
Town C
Town D
Town B
Town B
Town A
I want to do a chart which shows how many times each “town” appears in that one column. 
Is that possible?
------------------------------------------------------------------------------------------------------------------