I tried to create a line chart with two data series (two lines) using VBA:
ActiveChart.ChartType = xlLine
ActiveChart.SetSourceData Source:=Range( _
The code should produce this chart, but it throws an 1004 error message on 'SetSourceData'
How is the macro to be re-written on the setSourceData line for it to work.
Help is much appreciated. Thank you very much in advance.
I have attached my sample file for your convenience.