Problems with SetSourceData.
Problems with SetSourceData.
(OP)
Hi!
Trying to plot data from selective curves from the power-grid. Since the number of data constantly changes I'm having problems with:
ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range("A1:B???"), PlotBy:= _ xlColumns
I would've loved do write it like this:
ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range(Cells(1,1),Cells(2,x)), PlotBy:= _ xlColumns
But that doesn't work, someone knows how to get around it?
Thanks in advanced from Sweden.
Trying to plot data from selective curves from the power-grid. Since the number of data constantly changes I'm having problems with:
ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range("A1:B???"), PlotBy:= _ xlColumns
I would've loved do write it like this:
ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range(Cells(1,1),Cells(2,x)), PlotBy:= _ xlColumns
But that doesn't work, someone knows how to get around it?
Thanks in advanced from Sweden.




