XY Chart ontinued line

g.bon · External Since: Sep 14, 2009 Posts: 2

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 · External Since: Jan 08, 2009 Posts: 187

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

g.bon · External Since: Sep 14, 2009 Posts: 2

Thanks very much,
Exactly what I was looking for.

GB

"Luke M" <LukeM RemoveThis @discussions.microsoft.com> a écrit dans le message de
news:55EE892A-90ED-4F84-910D-C2D394FAA523@microsoft.com...
> 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)
> --
> 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
>>
>>