barplotexcelhistogram
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:
Use a Scatter Plot where the horizontal axis is time. Below is a screenshot of an Excel sheet where two temperatures are shown. Temp 1 starts at 9:00:00 AM and increments by 1 minute and 26 seconds. Temp 2 starts at 9:30:00 AM and increments by 2 minutes and 53 seconds. They are both plotted in the graph.
As shown in the plot, the blue Temp 1 has been "selected" in the graph and the corresponding graph formula is:
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$27,Sheet1!$B$2:$B$27,1)
When I select Temp 2, the corresponding graph formula is:
=SERIES(Sheet1!$E$1,Sheet1!$D$2:$D$27,Sheet1!$E$2:$E$27,2)
Both Temp 1 and Temp 2 uses the same x-axis and y-axis.
There is a second way to do this where the blue series has its own x-axis and y-axis, and the red series has a different x-axis and y-axis. However, I wouldn't recommend this scheme because it is typically too confusing for others to interpret the results. It requires that you assign one (or more) of the lines to a secondary y-axis and then a secondary x-axis. Here are the steps:
1) Right click on the series that you want to assign to the secondary axes. Select "Format Data Series". Under "Series Options" select "Secondary Axis". That will assign the selected series to a secondary y-axis.
2) With the series still selected, go to the "Chart Tools" "Layout" "Axes" selection on the ribbon. Click "Secondary Horizontal Axis" and pick whatever options you want. That will assign the selected series to a secondary x-axis.
Below is an example. I purposely changed the color of the text of the lower x-axis and the left y-axis to blue to signify that these are the axes to use for the blue series.
I changed the color of the text of the upper x-axis and the right y-axis to red to signify their use for the red series.
Notice that the two y-axes have different scales. The blue y-axis runs from 0 to 90, while the red y-axis runs from 0 to 100.
Notice also that I set both x-axis to start, stop, and increment at the same values. If you set the increment of the two x-axes to two different values, this graph can be even more confusing.
Assuming you're using Excel 2007, data labels are added through the "Data Labels" selection. As shown below, cells A2:A5 contain the data Items. Cells B2:B5 contain the data Values.
1) Select cells A2:B5
2) Select "Insert"
3) Select the desired "Column" type graph
4) Click on the graph to make sure it is selected, then select "Layout"
5) Select "Data Labels" ("Outside End" was selected below.)
If you don't want the Values as the Labels, you can click on the desired label, click twice so that it's the only thing selected, and then enter your new label information in the formula bar.
Best Answer
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.