+ Reply to Thread
Results 1 to 2 of 2

drop down box using reference from another cell in chart is it possible ?

  1. #1
    Registered User
    Join Date
    03-10-2005
    MS-Off Ver
    Excel 2013
    Posts
    95

    drop down box using reference from another cell in chart is it possible ?

    hi guys,

    need your help again and again

    can we combine drop down box + check box into the graph? basically drop down box is for like items, regions, etc while the check box is month (so we have 12 check box here)

    the purposes is we can choose to compare between 2 or more months to see the items selling per city (drop down) or per region (drop down) etc

    i attached sample here..and you can see in the summary sheet that i make the sample of the chart + drop down + check box

    and i know this one is not easy..but at least a guide so i know where to start and how to do it piece by pieces

    here is the picture : Drop Down chart + check box.jpg

    thanks All

    note: attachment window still blank for me so i post the excel file in zippy : http://www9.zippyshare.com/v/41482482/file.html
    Last edited by koi; 09-27-2012 at 08:04 AM.

  2. #2
    Registered User
    Join Date
    03-10-2005
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: drop down box using reference from another cell in chart is it possible ?

    hi All,

    i finally manage to make the drop down box + chart using pivot table chart, then i added combo box form control in there, and using some simple macro so when i change the combo box it will change pivot table as well and shown in the graphic

    but i wonder if we can make the combo box to refer to another combo box input (we can manage this one using data validation but i dont know if we can using combo box)

    example in data validation

    A1:A3 = fruit, fish, bird (we set up this as domain_names in name manager)

    A4:A10 = different fruit type
    B4:B10 = different fish type
    C4:C10 = different bird type

    we set up all those figure in name manager as well

    and we set up B1 = domain_names
    C1 = sub domain names

    we can use =Indirect(B1) in C1 (data validation) so when B1 choose Bird...then in C1 we can have drop down box for different type of Bird

    i want to use this kinda things in combo box.. it is possible to do it? or can i have another similiar way?

    thanks for any input

+ 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