Thread: how can an empty cell equate to non-plot point rather than zero?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
tomj tomj is offline
external usenet poster
  
Posts: 1
Default how can an empty cell equate to non-plot point rather than zero?
if(cell="","",cellvalue)

Here, if logic determines that a cell is empty, the cell will be empty but
the plot will show zero for the cell.

if(cell="",na(),cellvalue)
Here, if logic determines an empty cell the cell will be shown as #n/a, but
the point will be a non-plot.

How can one statement cause an empty cell but show as non-plot?


Reply With QuoteReply With Quote