PDA

View Full Version : Graphs: Return null value.



Benzadeus
12-17-2010, 05:50 PM
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
12-17-2010, 06:38 PM
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
12-18-2010, 05:40 AM
Yes, that will do.
Thank you.

Benzadeus
12-18-2010, 05:43 AM
Err... where can I mark this thread as solved?

Bob Phillips
12-18-2010, 09:42 AM
Thread Tools dropdown at the head of the postings.