I think the problem with the current code is this,
If TypeOf chk Is CheckBox Then
it should be probably be this.
If TypeOf chk Is MSforms.CheckBox Then
When I make that change the code runs and creates various charts, based on the checkboxes' the user checked.

So try making that change.