Force gaps in chart based on (zero) value

[BartC]

I have a chart which is based on calculated data (formula). Where the base data has 'gaps', the formula show zero. Given that the result of a formula can never be a 'real blank'.
As a consequence, the resulting chart also cannot show gaps, instead it jumps to zero.

I am desperately looking for a solution, to force the chart to show gaps.

Any help wouold be greatly appreciated!

Many thanks
Bart

BTW I am looking for a solution without VBA if possible.

 

[Scott T]

See if this video helps.

https://youtu.be/W-QAx3_kL30

 

[BartC]

Marvelous, that's just what I needed!!
Thanks a lot, Scott.

Bart

 

[BartC]

For anyone else reading this post, if you want to skip the Youtube: let your formula result in n/a# by using =na(). The chart will not drop to zero.