Chart Series Hide/Unhide using CheckBox form control

This is the best I can come up with. The main problem is that the checkbox does not know where it is or even what its name is. You can link a checkbox to a cell and when you click on it, the cell toggles between True and False. The problem is that even though the linked cell value changes, it is not detected as a change in the change event code. Normally when code changes the value in a cell you wind up in an infinite loop unless you turn off events.

So each check box is assigned its own subroutine which passes parameters to the code that turns the series on and off. The checkbox subroutines call the main subroutine with two parameters: Series Number and Row Number that contains the checkbox. The main subroutine expects to find the linked cells in Column O. Change this if your setup is different.

Please Login or Register  to view this content.