Check box requiring F9 to react?

I came across an charting example where clicking a check box immediately substituted blanks for a series via an if function on the check box status. The example had both the data and the chart on the same page. My implementation has the data on one tab and the chart on another and unexpectedly requires hitting F9 (recalc) for the series to display or not based upon the status of the check box.

Do I have to have the data and the chart on the same tab for the status of the check box to be immediately reflected on the chart? The auto-calc option (vs Manual) is turned on.

Thanks,

Jnana