General discussion

Locked

Excel-how a graph interprets blank cells

By Mark S ·
I have a spread sheet that produces some graphs. Some of the graphs are keyed off cells that use formulas to create the value. The problem is that even though I have selected "interpolate" for how the graph interprets a blank, it recognizes blank cells as a zero value and places them on the graph as such. I know there are ways around it, ("hide" those columns, etc) but this forces me to do a lot of maintenance on a lot of charts! Is there a "bug" in my software, or is this a deficiency inherent in Microsoft Excel?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel-how a graph interprets blank cells

by DKlippert In reply to Excel-how a graph interpr ...

Have you tried something like:
=IF(ISBLANK(A4),NA(),A4*B4)
NA() will cause the graph to draw a straight line between non-zero points.

Collapse -

Excel-how a graph interprets blank cells

by Mark S In reply to Excel-how a graph interpr ...

IT WORKS! Thank you very much.

Collapse -

Excel-how a graph interprets blank cells

by Mark S In reply to Excel-how a graph interpr ...

This question was closed by the author

Back to Desktop Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums