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.
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.