Alter the width of bar chart to look like BOX chart

[ThilakBabu]

Hi Microsoft tech team,

I'm creating a bar chart with 3 series with 80% overlap as shown in below screenshot 1.
I wanted to check feasibility to reduce the individual bar width such that I can get a box chart like structure as shown in second screenshot 2. Please let us know about the possible options to achieve box like structure.

Screenshot 1 :

Data used to generate this chart is as below :

Metrics	Value
Total Market for Paper Towels	100
Paper Towels in xxxx purchase	50
Spent by xxxx Shoppers in  Total Market	20

Series type as below :

Attached the Excel as well here (file - BarToBoxChart.xlsx)

We would like get the above bar chart to appear like below, is there any possibility on achieving it by changing the overlap or some other property.

Screenshot 2 :

Any leads will be much appreciated.

Thanks,

Thilak Babu

[#2]

Sounds like you are trying to create a Treemap chart? https://support.microsoft.com/en-us/office/create-a-treemap-chart-in-office-dfe86d28-a610-4ef5-9b30-...