Remove legend if value is N/A

defy

New Member
Joined
Dec 19, 2010
Messages
5
Hi all!
Here to scoop up some of your help again =) =P

I have a bar chart and a lot of it is blank because a lot of the values i have are n/a (so zero wont show) is there a way to prevent the cart d\from displaying data if it is n/a or 0? maybe a macro of some sort?

Cheers yall! ;)
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,108,749
Messages
5,524,609
Members
409,593
Latest member
anand31

This Week's Hot Topics

Top