Looping through to add series into a dynamic range chart
 

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

Looping through to add series into a dynamic range chart
 

show us what u have done so we can assist you

" wrote:

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