exclude blank cells in a line graph

  • Thread starter Thread starter Whitehorn
  • Start date Start date
W

Whitehorn

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?
 
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
 
Thanks. I'm looking to graph all calculated data that are currently
available (including 0) and ignore future calculations that will take place
in subsequent weeks.
 
Back
Top