Link to home
Create AccountLog in
Avatar of darls15
darls15

asked on

Show/hide a pie chart in Excel if the a cell equals 0

Hi Experts

I have a chart (Chart16) on a worksheet tab (Devices) which I would like to completely hide (including chart titles, legend, values etc. ) if the value in Cell N17 is 0 and display if it's anything else.

Is this possible?

Thanks
darls15
ASKER CERTIFIED SOLUTION
Avatar of Redheadache
Redheadache
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of darls15
darls15

ASKER

Both solutions work perfectly, thank you both for your help :)