xy scatter plot

[Andrew]

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...

 

[Pete_UK]

Do you have Excel dates in the cells you want to use for the x axis? If so,
put this in a helper cell:

=YEAR(D1)

formatting as number or general, and then copy down, assuming your dates are
in column D.

Then use the helper column as the source data for the x axis.

Hope this helps.

Pete

 

[Jon Peltier]

You say what you're trying to get, but not what you get instead. Just
"nothing is working".

- Jon