I have a line graph which is pulling WAY too much information over a long period of time for it to be very legible. I figured using an interactive chart would give the opportunity to list only what I want to look at in the graph by simply using a combo box to select only a certain range of cells. I've gotten as far as making it functional per this tutorial:
http://marketingland.com/how-to-crea...in-excel-57816

That has allowed me to list a single variable in the corresponding chart but I want to be able to "hide" data from the chart using check boxes or buttons that way I can compare all the data lines or just a couple lines. I can use a button to clear a certain range of cells which deletes the information from the graph but I can't toggle the information and thus the chart line on and off. Is there a way to do this?