Recorded macro not giving the same result as the by-hand result

I should like to master the vba code for drawing a graph but I hit a problem :

On my practice worksheet I have a sine function. In column 5 degrees of arc from 1 to 359, in col 6 the sine function.

(1) First I make a graph by hand INSERT > Scatter > select the smooth line option. This then draws a nice sine wave on my worksheet. This is what I want, but I need to use vba to do the same thing.

(2) Rub out the chart I just made.

(3) Do exactly the same thing as in (1) but with the macro recorder on. Stop recording and then run the macro.

(4) Now, a different chart appears with two straight lines on it. Not a sine wave as expected.

The code from the recorded macro was

Please Login or Register  to view this content.

What to do, please ?