I have different values for both X-axis and Y-axis.
Eg:
-- removed inline image ---
If I were to change the range, excel will produce two graphs. How could I edit my code so that the x and y axis will change according to the values?
'Create Graph For Coil2
With ActiveSheet.ChartObjects.Add _
(Left:=550, Width:=375, Top:=55, Height:=225)
.Chart.SetSourceData Source:=Sheets("Program").Range("A14:IV14")
.Chart.ChartType = xlXYScatterLines
End With
Eg:
-- removed inline image ---
If I were to change the range, excel will produce two graphs. How could I edit my code so that the x and y axis will change according to the values?
'Create Graph For Coil2
With ActiveSheet.ChartObjects.Add _
(Left:=550, Width:=375, Top:=55, Height:=225)
.Chart.SetSourceData Source:=Sheets("Program").Range("A14:IV14")
.Chart.ChartType = xlXYScatterLines
End With