Thread: How to make Excel Chart not to display empty cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
Marko Pinteric
 
Posts: n/a
Default How to make Excel Chart not to display empty cells?

I have a range of IF formulas. Sometime IF returns number, sometimes
"". The problem is that chart displays "" as value 0. Is there a way
to force chart not to display those empty values?

IF(condition; number_value; "")

Marko
Reply With QuoteReply With Quote