Hey Gang,
I am attempting to create a dynamic chart where info hides or appears using a checkbox. I have been able to make it happen for EITHER the vertical OR the horizontal, but cannot figure out how to do both.
In other words, I have multiple individuals on the vertical plane and multiple months on the horizontal plane. I currently have the following formula that hides one of the 5 individuals:
=IF($C$14=1,VLOOKUP($B$17,$B$2:$N$6,2,FALSE),"")
... in each of the boxes following the invidual (using incremental numbers 2, 3, etc), linked to the TRUE/FALSE conditional of the checkbox ($C$14 in this case). So checking or unchecking the box makes the info in the table appear and disappear, and so it does in the chart as well.
The problem is that it makes every available month appear and disappear. What I would like to do is also have a horizontal formula in the same space that also reacts with another check box linked to the months of the year. This way if I check BOB for June and July, I will only see Bob's data for only June and July.
Can anybody help. It does not appear that there is a "Normal" OR function that I could use to do something like =IF($C$14=1,VLOOKUP($B$17,$B$2:$N$6,2,FALSE),"") OR IF(HLOOKUP Function).
Thanks in advance.
Econdude
I am attempting to create a dynamic chart where info hides or appears using a checkbox. I have been able to make it happen for EITHER the vertical OR the horizontal, but cannot figure out how to do both.
In other words, I have multiple individuals on the vertical plane and multiple months on the horizontal plane. I currently have the following formula that hides one of the 5 individuals:
=IF($C$14=1,VLOOKUP($B$17,$B$2:$N$6,2,FALSE),"")
... in each of the boxes following the invidual (using incremental numbers 2, 3, etc), linked to the TRUE/FALSE conditional of the checkbox ($C$14 in this case). So checking or unchecking the box makes the info in the table appear and disappear, and so it does in the chart as well.
The problem is that it makes every available month appear and disappear. What I would like to do is also have a horizontal formula in the same space that also reacts with another check box linked to the months of the year. This way if I check BOB for June and July, I will only see Bob's data for only June and July.
Can anybody help. It does not appear that there is a "Normal" OR function that I could use to do something like =IF($C$14=1,VLOOKUP($B$17,$B$2:$N$6,2,FALSE),"") OR IF(HLOOKUP Function).
Thanks in advance.
Econdude
