How do I plot a line graph in Excel (the horrible new one) where I define the values of the points on the X axis?

What I've got is 6 sets of 5 values that I want to plot a line of each which are at the same 5 x values. I can't seem to convince the new excel to do anything other than assume my points lie at 1,2,3,4,5 on the x axis. I'm sure I'm missing something really obvious?

Post the excell thingy here I'll take a look

^ What he said. And, just plot any graph, right click, click 'edit data' or something like that and you can do all sorts with it then.

The XY scatter chart, is that what you are looking for?

Without seeing what you want to do with a supplied xls file, it's hard for me to think of what you want.

Quote from mrodgers :

The XY scatter chart, is that what you are looking for?

That's it thanks

Quote from ajp71 :

That's it thanks

Ha ha! Great!

I had about 30 compressive strength curves of our material that I was trying to plot at work. I graphed and graphed and graphed for hours until someone finally told me the XY Scatter. I even had the chart for different material and still couldn't figure out how it was plotted. Your problem just sounded very similar to my problem.