Charting Blank Values

[levy8450]

Hello,
I have an Excel line graph chart. Some of the data fields for some of the series end before other series. In these cases, the line swoops to zero and looks terrible. If I delete the values in the series after the last valid value, the line in the chart ends, rather than goes to zero, and that's what I want.

The problem is that the data is a formula. I can tweak the formula to be blank after the last valid value, but Excel interprets that as zero and thus the line swoops to zero.

Anybody know of a way to have a formula result such that the chart interprets the cell as blank (and thus skips it) rather than interpreting as zero?

Thank you thank you.

Peter

 

[Mala]

Try getting the formula to return NA() instead of "" - e.g.
=IF(ISBLANK(D26),NA(),B20^2)

 

[levy8450]

Thank you, Mala. Your suggestion works fine!