Hi all,

My "Charts" worksheet includes a scatter chart called "Burnup". The scatter chart includes 2 series: "series1" and "series2".

I would like a cell on a different worksheet, the "Data" worksheet, to toggle the visibility of these 2 series in the chart. That cell is !Data$E$7.

Can anyone propose some VBA that will show the 2 series when the value in !Data$E$7 is greater than zero, and hide the 2 series when the value is blank or zero.

Thanks experts!

JayUSA