Show blank instead of zero in graph

[plumberef]

Trying to graph some calculated values and encountered a problem when the calculated cell is a blank and graph will display that point as 0. See attachment.

Tried using IF statement to insert a blank ("") when calculation is not possible but graph will still display the blank as zero.

Please help. Thanks.

[Pete_UK]

Change the formula in J15 to this:

=IF(I15="",NA(),I15*9)

then copy down. This returns an error instead of blank, and the graph ignores it.

Hope this helps.

Pete

[dilipandey]

HI plumberef,

Try using NA() instead of ""

=IF(I15="",NA(),I15*9)

See attached:- Book2 blank instead of 0 in graph.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>