Help

G

GC

Hello,
I am trying to set the series of 4 different charts with data from 4
seperate sheets. My sheets are called S1, S2, S3 and S4.
In the example below, I want to substitute the 1 with the variable Count.
What would be the correct syntax.

ActiveChart.SeriesCollection(1).Values = "='S1'!R2C16:R37C16"
Next

I have tried the following:
ActiveChart.SeriesCollection(1).Values = "='S"& Count"'!R2C16:R37C16"
and many variations of this. Can't seem to get it right.

Cheers,
Gerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top