The mekko plot is used to visualise categorical data over a pair of variables and still seeing the absolute numbers of the elements as a kind of weighting. It is inspired by the marimekko IBCS template.
The plot is run twice,...
...once for each period.
SAVING THE PLOT
To save the plot as a PNG file, click on the small camera icon on the top right corner of the plot.
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
You can choose the dimensions you want to plot on the vertical and horizontal axes, and which metric to plot.
The top items in terms of total value are plotted the vertical axis, while the other items are aggregated together. The items summed together are plotted in light grey color.
You can change the number of top items to plot for each axes.
You can choose to have the value labels plotted in their absolute value....
...as percent of the grand total...
...as % of the row total of each item.
or as % of the total of each vertical category.
Negative values on the Y axis will be plotted as shown in the example below. Label position might need manual adjusting.
Since negative values on the X axis cannot be plotted in a mekko plot, the negative values will be dropped and an error message will be shown.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...you can move the value labels around oand adjust their position.
It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.
Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.
Draw and edit your shapes.
ADD PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Add your message in the text box, one chart at a time.
Once you have finished writing the message for a chart, click on the 🚀 Submit.
Your message will appear above the chart title
Now write another message on the text box of a different chart.
Click submit. Your second message appears above the second chart. You might need to adjust the position of your labels.
The downloaded image of the chart contains the message.
The chart title is set on three lines: the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").
You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.
CHOICE OF COLOR PALETTE
Avoids decorative use of colors. Can display up to 5 different tones.
Similar pallets are available in other colors (greens, blues, reds,...)
This elegant palette is both beautiful and functional.
This bright palette contains clusters with distinct color separations.
This fresh palette contains modern tones and stunning highlight colors.
BLUE & GREEN PALETTE
This contiguous palette creates a bi-chromatic chart in cool subdued hues.
KHAKI & DENIM PALETTE
This subdued palette great for complex charts.
This subdued palette is good for charts requiring contrast between segments.
HEATING UP PALETTE
This bright palette is great for complex charts.
POWERBI DEFAULT PALETTE
A lively, colorful palette.
This functional palette minimizes the risk of confusion between colors .