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
What to do, please ?
Bookmarks