Dynamic chart with check box & scroll functionality

[pauli618]

I have multiple data sets for which I have modified a chart where I can scroll and zoom through the data plot, depending on the timeframe I'm looking for.

I would now like to add the functionality of selecting which data sets to plot on my chart by using checkboxes or radio buttons. I have attached my workbook (MVPC3) as well as an example of the checkbox functionality I would like to add. However, I'm concerned that if/when I add the additional named ranges needed for the checkbox, that I may screw up the scroll/zoom tool I finally got working. Is this a valid concern? Getting my chart this far has been a significant learning process and I'm not as comfortable as I would like to be with this next step before diving in.

An added bonus would be for the Y axis values to adjust automatically based on the plotted data range(s), as there is a wide swing in values.

[Andy Pope]

You just need to follow the principles in the interactive example file.

I have added the blankseries and berk1series named ranges.
The chart has a checkbox for Berk1 series.