Automatically create a chart
I am in the process of automating a chart creation and get stuck on this line:
'WS is declared as a worksheet
ActiveChart.SeriesCollection(1).values = WS.Range("G34, I34, K34, M34, O34")
I want to create a series in a chart by selecting multiple noncontinguous
cells, but
I run into errors executing this line.
Can someone point out what is wrong?
Thanks,
YH
|