Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
Problem adding vertical marker line to line chart | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |