Looping through to add series into a dynamic range chart

[YehWei]

Hi,

I'm wondering if anyone could point me an easier way to add 20 to 30
series to a dynamic range chart maybe through the use of looping rather
than adding the series one by one and changing the "refers to" variable
to the offset formula for dynamic range?

Thanks!
Yeh Wei

 

[Guest]

show us what u have done so we can assist you