Graphs: Return null value.

[Benzadeus]

Hello,

Suppose you have this data:

Jan Feb Mar Apr May Jun
Setup 150 130 3 100 200

All respective's month's data are filled, except Apr, that is null.

If I plot a line graph, I'll have a discontinuos part between Mar and May. If I put a formula that return "" (empty), the graph will interpret 0 from that and will draw a line.

The fact is that I need to set a formula there. Do you have any suggestions to discontinue the graph between Mar and May, without using VBA?

Notice that, in my real problem, the formula of one or more cells can be empty and I need this descontinuity.

[p45cal]

May not be the whole answer:
try changing the formula to return:
NA()
instead of:
""
the chart will intercalate, rather than plot 0, will that do?

[Benzadeus]

Yes, that will do.
Thank you.

[Benzadeus]

Err... where can I mark this thread as solved?

[Bob Phillips]

Thread Tools dropdown at the head of the postings.