Visualisation issue

[TG2812]

Hello,

I’m facing a challenge with excel chart.
I have a list of products that can be mounted on different machines of different tons (say 18 to 40 tons or 20-30 tones etc). These same products are characterized by their capacities expressed in litre (400,500,600, 750L etc..up to 6000L). There can be several products sharing the same capacities . If I use stacked bar to show the spread of carrier to age, the problem is that having several products of the same capacities will cause the bars to overlap.

How to effectively handle this issue? What would be the best visualization to map my portfolio/market?

I’m trying to get my head around it without much success. Any guidance or inputs would be much appreciated

 

[TG2812]

Hello,

I have tried several attempts and chart visualization but nothing truly works. I think I can only use bars or line to deals with the carrier range. Thus, I will always have to deal with this bar overlapping issue.
If there’s a different way to approach the problem, I would very much appreciate to read it

 

[felixstraube]

Could you share some of you data. Without that is it pretty hard to understand what you really want.
And show us what the result should look like.

What would this be?

the spread of carrier to age,

 

[TG2812]

Thank you very much for your reply! I found a way to do it and works like a charm