Issue with Dynamic charts with check box

[jddhivyan]

Hi Chandoo,


I refer to the example that you have provided for the dynamic charts with checkboxes:

http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/


I did use this example and it worked really well..


But when i have multiple charts with multiple source tables.. the checkbox of one chart affect another chart as well.. this happens even though the refernces are for compleetly different cells.


Please advise.


Thanks

John

 

[Luke M]

You'll need to set up different sets of data for each check box you want individually controlled. As in Chandoo's example, they all have the same basic formula of:

=IF(CheckBox,Relevant_cell,NA())