Simple Excel 2007 Line Chart Question

[jamie_in_nj]

Way back in the past, pre-Excel 2007, I used to create simple charts and it always seemed to go smoothly. I am struggling with trying to do this in Excel 2007 though.

I have a grid of data that looks sort of like the following, with mortality data:

Age qx1 qx2 qx3
60 .001 .002 .003
61 .004 .005 .006
...
99 .350 .450 .550

I want a line chart that shows the horizontal axis with 60, 61, etc., the vertical axis going from .001 to say .60, and three lines going across showing the values from 60 to 99 for each of qx1, qx2, and qx3.

This seems like it would be easy to do, but I'm struggling with it. Can someone help me get started?

Thanks!!

 

[VoG]

Select all the data and insert an X-Y scatter chart. Then use chart options (right click a point > Format Series) to add lines between the points (and delete the point markers if you wish).

 

[jamie_in_nj]

Awesome, that's working for me. I might have some more questions, but that's got me on my way. Thanks so much!!