Hello everyone,
I have a big problem to make a horizontal bar chart with different width of each bar.
Please see the attached photo (so sorry for the poor quality of photo, the varied width of each bar depends on the % segment it accounts for.
I tried Marimekko chart but only for column bar chart and excel doesn't support for horizontal bar chart.
So I think we need excel VBA or other tools to do it, plz help me if you can make it with only excel because I don't know excel VBA.
Thank you so much in advance.
Hi Mai,
The good news is you don't need VBA. The bad news is you shouldn't really use this type of chart. Data visualisation expert, Stephen Few, documents the problems with this type of chart here. And a better alternative.
That said, if you want to show the Marimekko as a bar chart you can use the Excel Camera Tool to rotate it on its side.
Mynda
Hi Mynda,
Thank you very much for your answer.
This information is very helpful for me. Unfortunately, my boss requires this type of chart so I have no way to consider Stephen's solution.
I think it's time to learn VBA to make it automatically. Hmm. I don't know where I can begin ?
Mai
Hi Mai,
VBA won't build your chart either. It's not an automation issue, which is what VBA does, it's a Excel chart limitation. You simply can't make a Marimekko on its side in Excel. The solution is to use the Camera Tool (linked to in my reply above) to rotate an image of the chart.
Mynda
Hi Mynda,
you are right that it's a Excel chart limitation. However, I'm using a form to create this type of chart (not Marimekko chart) but don't know how to edit as I want.
I guess someone created its by VBA because I just have click on "User form" and automatically making this chart as my attached photo. It just have some bars not actually a chart in excel.
I'm so curious about this.
Hi Mai,
Jon Peltier has a tutorial on how to build the Marimekko chart in Excel. Then you just need to use the Camera tool to rotate it.
Mynda
Thank you very much for your support.
I hope I'll success with this way !
