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