I am trying to add a data series to an existing chart.
I have defined k in the program and want to select cols k+7 and k+2 as
the data form the sheet "Data" to add to the chart.
I have:
ActiveChart.SeriesCollection(2).Values = "=Data!R2C" & k + 7 & ":R24C" &
k + 7
ActiveChart.SeriesCollection(2).XValues = "=Data!R2C" & k + 2 & ":R24C"
& k + 2
but this does not select the right data - it actually selects data
G2:g24 and b2:b24.
Could someone tell me the correct syntax please or the correct way to do it?
Thanks
Chris
Chris
Bookmarks