Creating dropdown menu list for Chart Column Heading

  • How do I create boxes or dropdown menus in my chart headings that allows the flexibility to list only the specified items in the columns. The following is what I currently know that I need to specify, but I also, need to know how to add to it or delete from the menus in the future or any other menus I decide to create within a new column of data, etc.. See Chart sample.




    Numeric Combinations Heading: List
    last 6 even and odd rows
    last 6 odd rows
    last 6 even rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows
    last 50 odd rows
    last 100 odd rows


    Positions Heading: list
    last 3 odd rows
    Last 5 odd rows
    last 6 odd rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows


    How many POS: list
    list all 2s
    list all 3s
    list all 4s
    list only 2s and 3s
    list only 3s and 4s
    list only 2s and 4s
    last 5 odd rows
    last 6 odd rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows
    last 50 odd rows
    last 100 odd rows


    How many Hits: list
    list all 1s
    list all 2s
    list all 3s
    list only 1s and 2s
    list only 2s and 3s
    list only 1s and 3s
    last 5 odd rows
    last 6 odd rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows
    last 50 odd rows
    last 100 odd rows


    Selection: list
    list all E s
    list all On s
    list all Off s
    list all iffyOn s
    list all iffyOff s
    last 5 E s
    last 10 Es
    last 15 Es
    last 20 Es
    last 5 iffyOn s
    last 10 iffyOn s
    last 15 iffyOn s
    last 20 iffyOn s
    last 5 iffyOff s
    last 10 iffyOff s
    last 15 iffyOff s
    last 20 iffyOff s
    last 5 On s
    last 10 On s
    last 15 On s
    last 20 On s
    last 25 On s
    last 30 On s
    last 35 On s
    last 40 On s
    last 45 On s
    last 50 On s
    last 5 On s
    last 10 On s
    last 15 On s
    last 20 On s
    last 25 On s
    last 30 On s
    last 35 On s
    last 40 On s
    last 45 On s
    last 50 On s
    last 5 odd rows
    last 6 odd rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows
    last 50 odd rows
    last 100 odd rows


    Selection Accuracy: list
    list all 1 s
    list all -1s
    list all 0 s
    last 5 1 s
    last 10 1 s
    last 15 1 s
    last 20 1 s
    last 25 1 s
    last 30 1 s
    last 35 1 s
    last 40 1 s
    last 45 1 s
    last 50 1 s
    last 5 -1 s
    last 10 -1 s
    last 15 -1 s
    last 20 -1 s
    last 25 -1 s
    last 30 -1 s
    last 35 -1 s
    last 40 -1 s
    last 45 -1 s
    last 50 -1 s
    last 5 0 s
    last 10 0 s
    last 15 0 s
    last 20 0 s
    last 25 0 s
    last 30 0 s
    last 35 0 s
    last 40 0 s
    last 45 0 s
    last 50 0 s
    List only 1 s and –1 s
    list only 1 s and 0 s
    list only –1 s and 0 s
    last 5 odd rows
    last 6 odd rows
    last 10 odd rows
    last 12 odd rows
    last 20 odd rows
    last 30 odd rows
    last 50 odd rows
    last 100 odd rows

  • Hi dk,


    Have you tried Data / Filter / Autofilter for this? Might be a start, but I don't think it will give you everything you want though - - and I'm not sure I understand all of the filters you are trying to define.


    It might be possible to build "Advanced Filter Criteria" then put them in a drop down menu or a userform, then display the results of the filter on a different sheet.


    Could you further explain the filters you are trying to get? example - - what does "last x odd/even rows" mean? And how do you determine the "Last x" of any filter - are the rows always in the same order or do they get sorted somehow?


    .....Ralph

  • Thanks Ralph for your response. I reviewed further your advise to check out Autofilter and I played around with it until I got it to work to meet my needs. Thank you.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!