It would be good to know what are you doing exactly when as you said, you "do this in Excel, it seems to create TWO charts".

If one follows the manual procedure in Excel to create XY-scatter graph, it prompts to choose one of 5 available chart sub-types. You may choose there what you need.

Regards


>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