Hi.
I'm trying to plot data, e.g.
Col A: 10 ,20 ,30 ,40 ,50
Col B: 100,200,300,400,500

Col A to be the x Axis, and Col B the Y axis.
When I do this in Excel, it seems to create TWO charts, taking Col A as the Y axis for the first chart and Col B as the Y axis for the second chart.

Really what I want to do is produce a graph, plotting Col B against Column A, i.e. Col A = X axis and Column B = Y axis .

Anybody know How to do this in Excel.
Regards,
Gerard