Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Series Range Phil Charts and Charting in Excel 2 April 18th 07 03:00 PM
dynamic range and series cass calculator Excel Worksheet Functions 1 February 23rd 07 11:46 PM
need help updating chart (series in dynamic range) Jeff Charts and Charting in Excel 1 April 1st 05 02:35 AM
Dynamic series in Chart Jeff Charts and Charting in Excel 2 February 24th 05 11:54 AM
Need help with looping through a dynamic range TBA[_2_] Excel Programming 3 December 14th 03 01:54 PM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"