If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XY Chart ontinued line
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 |
#2
|
|||
|
|||
XY Chart ontinued line
Instead of returning a blank "", have your formula return the #N/A error
(which causes charts to skip that point. Example: =IF(A2A3,NA(),A3) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "g.bon" wrote: 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 |
#3
|
|||
|
|||
XY Chart ontinued line
Thanks very much,
Exactly what I was looking for. GB "Luke M" a écrit dans le message de ... Instead of returning a blank "", have your formula return the #N/A error (which causes charts to skip that point. Example: =IF(A2A3,NA(),A3) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "g.bon" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|