Thread: How not to plot zero in graph ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mire Mire is offline
external usenet poster
  
Posts: 8
Default How not to plot zero in graph ?
I am trying to figure out a way to eliminate plotting the LINE
chart when the value is negative or no value.
I use NA() but the graph plot zero !
=IF(B10,B1/C1,NA())

I need to use a pie-graph.

Tnks in advance
M



Reply With QuoteReply With Quote