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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andrew" wrote in message
...
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...