Assigning data source to chart

K

K Dales

Set the Values and XValues properties to be the actual
range object, not a formula - for you this is complicated
by the fact that you can't use R1C1 notation for the range
address, but this should work:

ActiveChart.SeriesCollection(ColNum).XValues =
ActiveSheet.Range(ActiveSheet.Cells(i +
1,2),ActiveSheet.Cells(i + 1,10))

etc...
 
Top