SetSourceData Chart

I'm using the following code

ActiveChart.SetSourceData Source:=Sheets("test").Range("A" & RowEnd(i - 1) & ":A" & RowEnd(i), "F" & RowEnd(i - 1) & ":F" & RowEnd(i)), _
            PlotBy:=xlColumns

I only want column A and F to be in my chart, but im getting row A to F, what should the code be ?

Thanks

Try this:

ActiveChart.SetSourceData Source:=Sheets("test").Range("A" & RowEnd(i - 1) & ":A" & RowEnd(i) & ",F" & RowEnd(i - 1) & ":F" & RowEnd(i)), _
            PlotBy:=xlColumns

Thx, works!