question about bar charts

[gossip_boi]

Hello everybody! I have a really interesting task. I have to make a bar chart but there must be only non-empty cells. I mean, for example, in columns A, B, C there is some information but the D is empty. How can i solve the problem: if i choose from A to D i'm gonna have one zero bar (from the D column) but later there can be something which has to be displayed as usual. What can u tell me?

 

[Hui]

Named Formula are the only non-VBA solution
You can use the technique described here:
https://chandoo.org/wp/2012/12/04/f...ting-dynamic-charts-with-non-contiguous-data/
or
https://chandoo.org/forum/threads/d...rray-for-chart-from-non-contiguos-range.7683/