adding data to a chart

  • Thread starter Thread starter inquirer
  • Start date Start date
I

inquirer

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
 
Back
Top