Show / Hide Graph series via button.

[Steve_in_Kent]

I have a graph with multiple data lines on it. showing various years.

I can create buttons on the graph no problem.. what i want to do, is toggle via each button, the data series, so it shows/hides on each click.

is there a way to hide a data series?

Steve

[sdckapr]

The easiest way is to have the data series pointing to cells with formulas. The formulas can return the desired values or #NAerror based on the button (a check box could also be used instead of a button). The #NA's will not plot.

If you have legend and want to remove them with a toggle, it will require VB to actually add and remove the series...

Steve

[Steve_in_Kent]

thanks for the hint..

figured this out, using VBA to hide the rows where the data is shown, you can place a button on the graph, and added this code.

Worksheets("Scorecard").Rows("127:129").Hidden = False

Which will hide rows 127 to 129 on the named scorecard.

Steve