Hide 2 scatter chart series when a specific cell is empty

[JayUSA]

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

[jeffreybrown]

Jay,

Here's an option that could work for you. Toggle the value in E7 and see what happens to Series 2 in Column C.

[JayUSA]

Jeffrey, it works perfectly! Man many thanks! Jay

[jeffreybrown]

Hi Jay,

Glad this worked out for you. You're welcome!