Skip to Content
0
Former Member
Jun 23, 2009 at 07:56 PM

Dynamic Stack Chart display with Checkbox

42 Views

Hi All,

I would like to know how to use the checkbox in combination with a stacked column chart so the results are displayed dynamically. For Eg- if there are 5 selections and each with a check box, then by selecting each one, the graph would display their values and chart it accordingly.

I have seen some models that have this feature but don't know if they are using a built in excel function or if this is somehow defined in one of the properties for the checkbox ?

I know the standard function exists within excel to do this using an IF statement and a checkbox combo and would like to acomplish the same.

Thanks,

Kaushal.