I'm not following what you want for your X coordinates. Is 1;8 the same as
August 2001? If so, EXCEL doesn't know that. You'll need to enter the
month/year in a format that EXCEL knows before you can go further.

wrote in message
oups.com...
Hi All,

I cannot, for the life of me, figure out how to get excel to chart some
data of in the format of year;month to represent an age. This is a
common convention in the humanities, but I can't make excel do it.

Bascially, I want to plot data like this on an X-Y scatter plot

1;8 40
1;9 50
1;10 40
1;11 33
1;12 44
2;00 21
2;12 64

Thanks for any help you could give!