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?