+ Reply to Thread
Results 1 to 2 of 2

Showing/Hiding Chart series + Chossing different ranges for a single chart to display

  1. #1
    Valued Forum Contributor
    Join Date
    Warsaw, Poland
    MS-Off Ver

    Showing/Hiding Chart series + Chossing different ranges for a single chart to display

    Hi everyone!

    First of all, thanks for your time looking at this thread. I really appreciate it!

    Now the the serious stuff: I've attached a file I've been working on.


    As you can see, if you press the activex checkbox, the series will either appear/dissapear from the chart. I've got 2 ideas how to make such a chart more appealing/convenient for the user: I would like to have a combobox instead of a single checkbox. A combobox with all days of a week. By chosing Monday, only monday would be shown etc.

    The second idea which I have but have no idea how to make it work: I would like to give the user the possibility to chose which week he'd like to see on the chart. As you can see, there are multiple weeks in the columns B:H and J:P.

    I would like the user to be able to chose whether he'd like to see a comparison of the weeks between row 5 and 52 or 60 to 107.
    I'd prefer that to having multiple charts in one worksheet.

    If anyone has an idea how to resolve any of my "problems" I'd really greatly appreciate it!

    Thank you!
    Last edited by Bishonen; 07-14-2012 at 11:50 AM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Charts challange

    Thanks for amending your thread title.
    Last edited by Cutter; 07-15-2012 at 03:05 PM. Reason: Removed thread title request

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1