Richard has attended:
Excel Advanced course
Graph with tick boxes
Hi there,
I am trying to make an interactive graph with tick boxes which allows the user to hide a series or bring up more series.
The way i want to do this is by having a seperate table that links to the first table and use an IF statement to make the data visible and hid it when the box is not ticked.
I have created the check boxes and now need to make another cell populated with true and false in order to make my if statements work. when the box is ticked, i need to populate another cell with true (and false is not ticked).
So when i doulbe click the checkbox it takes me to the vb editor and i cant seem to make the box populate with a true if the box is ticked. What should a basic macro look like that allows another cell to populate as true, when the checkbox is ticked?
RE: Graph with tick boxes
Hi Richard, thanks for your query. Have you considered using the Pivot Table functionality to do this? It sounds like you're trying to achieve something a Pivot Table could do for you very easily.
It is possible to code what you're after but you need to capture the value from the checkbox, send it to a variable, perform a test on that value and then send a dependent output to the cell on the spreadsheet. Let me know if you want to proceed and I will post some generic code which should point you in the right direction.
Hope this helps,
Anthony
