View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] YehWei@gmail.com is offline
external usenet poster
 
Posts: 15
Default 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