Charting distribution of ages and hometowns

Use the FREQUENCY function.

       -A-- B -C- --D--
   1   Data   Bin Count
   2    22    20     6 
   3    24    22     2 
   4    25    24    10 
   5    25    26     3 
   6    23    28     3 
   7    23    30     1 
   8    21    32     0 
   9    23    34     0 
  10    27    36     1 
  11    27           0 
  12    23             
  13    20             
  14    20             
  15    23             
  16    24             
  17    30             
  18    19             
  19    24             
  20    23             
  21    35             
  22    19             
  23    25             
  24    27             
  25    20             
  26    23             
  27    20

The bins are in C2:C10. Then select D2:D11 and paste this in the formula bar:

=FREQUENCY(A2:A27, C2:C10)

Don't press Enter. Instead, press and hold the Ctrl and Shift keys, then press Enter.