exclude blank cells in a line graph

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?
 
B

Bernard Liengme

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
 
W

Whitehorn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I leave out blank cells in a line graph? 1
Zero value and bar graph 1
Blank cells in graph 8
Sum Error While Graphing 1
Graph Line Width ? 1
Graphing Question: Blank Lines Problem ? 2
Line graph showing '0' points 1
Remove the blank colum in the graph from merged cells 1

Top