BAR MEKKO PLOT
The bar mekko plot is a variable width bar chart. A bar mekko chart is an alternative to a bar chart, for instance to show product profitability, with gross margin as the bar height and sales as the bar width.
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 dimension you want to plot, and which metrics to plot on the X and on the Y axes.
You can choose on which axis metric to sort the chart.
For instance, you could plot Gross Margin in % on the Y axis and revenue Amount on the X axis: the area of the polygons will be proportional to the Gross Margin in value.
Alternatively, you could plot Average Unit Price on the Y axis and Units on the X axis: the area of the polygons will be proportional to the revenue Amount.
By default, the chart is sorted on the y axis metric.
It is also possible to sort the chart on the horizontal axis metric.
By default, the four top items in terms of total value are plotted on each axes, while the other items are aggregated together.
You can change the number of top items to plot, and you can choose to plot or not to plot the value of the other aggregated items.
Negative values on the Y axis will be plotted as shown in the example below.
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.
CHOICE OF COLOR PALETTE
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 .
Avoids decorative use of colors.
ENABLE PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Enable messages by setting the "enable plot messages" widget to True.
You can find the "enable plot messages" checkbox in the Run widget expander.
Hit the Submit button.
A text box will appear above each chart.
Add your message, 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.
The downloaded image of the chart contains the message.