Forum Discussion
ThilakBabu
Apr 09, 2024Copper Contributor
Alter the width of bar chart to look like BOX chart
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
1 Reply
- JKPieterseSilver ContributorSounds 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-362d5c624b68