Hello. I'm trying to make this macro,
Sheets("Concerns Chart").Select
ActiveChart.PlotArea.Select
ActiveChart.SetSourceData Source:=Sheets("Statistics").Range("A4:C10"), _
PlotBy:=xlRows
Sheets("Statistics").Select
which is above, I need to make it so next time the macro is ran, the Range goes from A4 to D4, then after that, A4:E4, then A4:F4, and so on. Whats the correct coding I need to do this? Thanks!
Sheets("Concerns Chart").Select
ActiveChart.PlotArea.Select
ActiveChart.SetSourceData Source:=Sheets("Statistics").Range("A4:C10"), _
PlotBy:=xlRows
Sheets("Statistics").Select
which is above, I need to make it so next time the macro is ran, the Range goes from A4 to D4, then after that, A4:E4, then A4:F4, and so on. Whats the correct coding I need to do this? Thanks!
