Hiding Zero Values in Charts

[mbeane]

Formula in progressive monthly results cells is =SUMIF($D$2:$D$99,$D121,F$2:F100), changing as the months evolve. Therefore, where nothing has happened, return is nothing; I suppose, "zero". However, the line chart I'm using to visualize progression still displays the zero values; meaning after the last value above zero is charted, the next and succeeding values drop to and chart zero. How can I hide the zero charting until a positive value is posted in the source cells? Same question would apply to bar charts, as well. 'Preciate whatever you can do to help.

 

[oldchippy]

Hi mbeane,


Try this,


=IF(SUMIF($D$2:$D$99,$D121,F$2:F100)=0,#N/A,SUMIF($D$2:$D$99,$D121,F$2:F100))

 

[mbeane]

Amazing! First, to get a response. Second, to get a response that quickly. Third, the response actually worked. Much thanks. I'll be telling others of your website!

 

[phungnt]

Hi

Help me!

How do I want hide value %0 in chart.