Mekko Chart

To illustrate a numerical value simultaneously differentiated according to at least two dimensions, Mekko charts are particularly suitable.

A distinction is made between two variants.

The Marimekko chart is to be understood as a two-axis stacked bar chart in which both axes represent 100%.

mceclip6.png

For instance, revenue can be represented simultaneously per product and region.

The Column Mekko, on the other hand is to be understood as a two-axis stacked bar chart, in which, however, the width of the columns is variable and where the axes represent 100%.

mceclip7.png

To create such a chart, follow these steps.

Open empower Chart and select one of the two Mekko charts.

mceclip8.png

You can then customize the data under Edit Data.

mceclip9.png

The data structure initially corresponds to that of a normal 100% or normal column chart, but with the difference of the additional "width row", which determines the relative width of the individual columns. It is often technically desired that the width is equal to the sum of the column values, so this is already preset.

When using the Transpose button, you have the option to swap rows and columns.

mceclip10.png

Note that the Width line is immutable.

Alternatively, you can link the chart to an Excel® file under Data and Excel Link.

mceclip11.png

 

 

 

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.