Hi,
I'm not sure where the problem is but im trying to create multiple series in a chart but cant figure out why this is not working. Need help.
LColumn is the last used column and 'col' gives me the letter of that column
Thank You.

col = Split(ThisWB.Cells(2, LColumn).Address(1, 0), "$")(0)
ActiveChart.SetSourceData Source:=Range("'MyData'!" & "B41:" & col & "41", "'MyData'!" & "B45:" & col & "45", "'MyData'!" & "B65:" & col & "65")