Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Changing Range Chart! (Excel 2000>)

    Some months back I posted a thread called Scrolling Charts starting at <post#=394337>post 394337</post#>, showing that a scroll bar can be used to sroll through the series of a chart. Hans and Steve gave some useful input on that technique!
    Her is another one of these examples, but using a drop down box to change which range should be plotted on the chart! It can be developed further for larger spreadsheets too! It is driven by a dynamic range name (see Insert | Name | Define)
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Changing Range Chart! (Excel 2000>)

    Nice example, thanks.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Range Chart! (Excel 2000>)

    This looks good Rudi

    I can see potential for this my end. Now talk me through it. I can't seem to see the formatting of the combo box and the Names, it may have got lost on download , who knows <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    So what comes first, the chart and then the combo etc
    Jerry

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Range Chart! (Excel 2000>)

    Wow....Talk about a time lapse warp..(or what ever you call it!)
    I could for the life of me not recall posting this today, untill I saw that it was March <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>...
    <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •