+ Reply to Thread
Results 1 to 3 of 3

Dynamic Chart with Active X Check Boxes - Adding drilldown

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2003
    Posts
    23

    Dynamic Chart with Active X Check Boxes - Adding drilldown

    Hi experts. I've attached a file where I made a dynamic chart using Active X check boxes to allow the user to select and deselect data they'd like to see from the 6 sets of metrics (Sheet 1). The goal was to overlay Open Orders, History and Demand with our forecast from 1, 2 and 3 months ago to quickly gauge our accuracy. This works great but I've now been tasked with adding another layer to this by allowing the user to drill down into this chart by selecting a product type, rather than just the totals.

    Typically I'd think a pivot chart would be the answer to allow a user to drill down and dissect data of their choosing but I think that's not an option if I want to maintain two chart types with my line graph being the optional forecasts. I'm hardly an expert as the attached is my first chart of this type so I was hoping to get input on conceptualizing a solution that would allow a drill down into our product types or whether a pivot chart could work as a solution. Ideally a data validation box allowing the user to select any number of product types would be best, but as far as I know that type of selection option is specific to pivots.

    Thanks in advance,
    Joe
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Dynamic Chart with Active X Check Boxes - Adding drilldown

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Dynamic Chart with Active X Check Boxes - Adding drilldown

    I split my data up into sections that I wanted to be filterable. I used a combo box that gave me a unique number for each filterable selection and used a lookup to view the portion of the data the user wanted to view.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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