1
vote
$\begingroup$

So a question you will have from here!

Q: What is Mekko? A. Its like a histogram. The bar chart can show information in two axes. Normally in a bar chart the y axis shows the variation and x shows just categories/labels. Check Mekko Graphics

So my question is if there are any open source ways of getting these into Excel :)

Update: All the charts on Types of Mekko Charts but specifically the Bar-Mekko as shown here:

enter image description here

$\endgroup$
  • 4
    $\begingroup$ Looking at the Mekko website, they advertise "32 chart types". I guess you will need to be a little more specific as to which type exactly you want. $\endgroup$ – Stephan Kolassa Nov 16 '12 at 8:48
  • 1
    $\begingroup$ If you don't get an answer here, you might try looking at Jon Peltier's blog. He does amazing things with Excel charts $\endgroup$ – Peter Flom - Reinstate Monica Nov 16 '12 at 11:49
  • $\begingroup$ These pages have templates as well as instructions: andypope.info/charts/colwidth.htm andypope.info/charts/colwidth2.htm $\endgroup$ – user80572 Jun 24 '15 at 13:44
5
votes
$\begingroup$

Some people call this a cascade chart, but cascade chart means waterfall chart to other people. Check out this tutorial on my blog: Variable Width Column Charts (Cascade Charts).

For a regular Marimekko chart, check this one: Marimekko Charts.

$\endgroup$
  • $\begingroup$ An answer from the man himself - Thanks! Will definitely have a look :) $\endgroup$ – Eshwar Dec 22 '12 at 8:51
1
vote
$\begingroup$

You can do it with a fair bit of manual intervention if you repeat the y values x times. So in your case you have a column of numbers that is 7 x 41, 6 x 51, 1 x30. Draw a normal column chart, and change the gap between columns to zero. Then you can use the "select data" editor to change the horizontal labels by pointing them to another aribtrary column - choosing mostly blanks. You can also manually change the column colours if necessary. What a bore though - lots of pointing and clicking.

$\endgroup$
  • $\begingroup$ Yeah we can but definitely can't afford the time :)! $\endgroup$ – Eshwar Dec 22 '12 at 8:50

Not the answer you're looking for? Browse other questions tagged or ask your own question.