I have a plot with more than 100 data series. I have created a checkbox control for each series so it will plot the series only if checked. Is there a way to link legend entries to appear only if the series is plotted? I have tried selecting the legend entry and entering a formula in the formula box to link it to the checkbox control, but it will not allow me to enter anything in the formula box. I have also tried linking the data series name to a cell that only has a value according the the checkbox control. That will update the name, but the line format is still in the legend entry. I would prefer to not have to delete 100 legend entries every time I want to change the plot around. Anyone know of a smart legend that will only show plotted series? Thanks.