hi there,

i thought i was good at graphing until i came across this problem. i need to make a graph that looks like this:
Screen shot 2012-06-20 at 8.57.38 AM.png

from this data like this
Screen shot 2012-06-20 at 8.50.23 AM.png

A is just a marker of where they live, B is yes or no, C is answer to a question

in reality there are 1000 data sets

also a similar graph is needed but with years know instead of the yes no answers in column B( imagine a wide variety of numbers from 0 to 50)

Screen shot 2012-06-20 at 8.58.58 AM.png

ive tried using formulas but they just havent been working..

thanks in advance!
james