Hi Yuri, thanks for replying.

I want a Line Graph..i.e with Points joined..
can Scattergraph do this


>Probably when you "do this in Excel, it seems to create TWO charts", you are using Line option instead of XY-Scatter option.
>
>
>>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