I am creating a xy scatter plot and am trying to get year as the x, for
example 2000, 2001...2009, and y as a percentage 1.0% to 3.0%, with
individual points that line up with the year and the percents, for example
you have 2001/1.3%, 2001/2.0%, 2002/3%, 2003/5%.....and on and on. I have
tried several things...changing the axis to general and number format,
nothing is working.

I used to be able to do this in the old excel but for some reason it isnt
working any more...