Thread: exclude blank cells in a line graph
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default exclude blank cells in a line graph
If the zero comes from a formula then modify the formula
So if the formula is =A2-B2 then use =IF(A2-B2=0,NA(),A2-B2)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Whitehorn" wrote in message
...
I've seen some good threads to exclude blank cells from an excel line
graph
by using NA()) instead of "". However, how do I accomodate cells that
could
= 0?


Reply With QuoteReply With Quote