XY Chart ontinued line

[g.bon]

Hi all,

With Excel 2007, I would like to draw an XY graph with continued lines and I
have some holes in my tab.
For example :
X A B
1 1 1
2 2 2
3 3
4 4
5 5 7
The line A is broken between 2 and 4.
The line B is broken between 3 and 5.

If I use the option "display all empty cells" for "linking data points with
a line", my lines are continued, just as I wanted.

But, unfortunately, when datas are not written directly in cells but
calculated, this option doesn't work anymore.
This is because my cell (A3 for ex.) is not really empty calculated.
I've tried to set the cell value with "" ; false or other thinks but nothing
works.

So can someone tell me what I should try to do please ?
Thanks,
GB

 

[Luke M]

Instead of returning a blank "", have your formula return the #N/A error
(which causes charts to skip that point.
Example:
=IF(A2>A3,NA(),A3)

 

[g.bon]

Thanks very much,
Exactly what I was looking for.

GB