Hello,
vba newbie here. I am trying to write a macro which will create multiple charts for me. I have two tables below each other with the same "x axis" values in column A. Columns B to I contain values I want to plot as different series in multiple charts. So chart one plots ("B7:B21") and ("B24:B48") as series, chart 2 plots ("c7:c21") and ("c24:c48") etc
I successfully wrote a macro to create and label the chart. Now I want to create a loop so that all charts are created. In a first step I want to replace "("B7:B21")" with a variable column letter.
I tried replacing:
ActiveChart.SetSourceData Source:=Range("B7:B21")
with
Dim col As String
col = B
[...]
ActiveChart.SetSourceData Source:=Range(col & "7:" col & "21")
This did not give me an error, but the selected range was all wrong, Excel actually created 16 series or so.

All help is appriciated.