Toggle Chart Suppress Values When Null

[lbunnell]

Is there a way to create a toggle button for a chart to show/hide the values when null?

[Gysbert_Wassenaar · Accepted solution]

You can do it with two charts, one that does show null values and one that does not, and show/hide the appropriate chart using the button. Or you can try mucking about with a macro.