How do I create a varied width stacked 100% bar chart?

[Tryndex]

Each event section has varying lengths. In each section, X, Y, and Z can make an appearance.

If both X and Z appear in the same event section, they'd share half the height of a column representing that section.

This chart, however, takes away all the significance from the timespan of each section, which makes it misleading for my purposes.

How can I make it so a column which represents an 80 seconds interval would be relatively 8x wider than a 10 second interval, and so on?

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How do I create a varied width stacked 100% bar chart?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.