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

show us what u have done so we can assist you

"YehWei@gmail.com" 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
>
>