View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default adding data to a chart

Sounds like k = 0
HTH
--
AP

"inquirer" a écrit dans le message de
u...
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