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

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

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

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