A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. The chart is named for the Pareto principle, and its purpose is to highlight the most important among a set of factors.
The plot is run twice,...
...once for each period. The bars and the cumulative % line are color-coded by their A,B,C class (A=up to 80%, B= 80 to 95%, C=95 to 100%, Loss = negative values).
You can force the plots to have the same scale setting the Fix scales ⚖️ widget to true.
This is the result.
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 Y axes, and which metrics to plot.
PLOT MULTIPLE METRICS
If you choose to plot more than one metric,
all plots will be ranked on the first chosen metric, "amount" in this example.
You can select as many metrics as you like.
PLOT ABSOLUTE VALUES
You can choose to see the absolute values rather than the percentages.
You can plot rankings as labels.
FILTER TOP OR BOTTOM 30 ITEMS
You can filter the plot to see only the top 30 items.
You can also filter the plot to see the bottom 30 items.
This can be useful to identify, for instance, the products that lose more money.
Imagine a situation like this, with many products, some with significant revenue (black bar) losing money.
To find the names of the 30 worse offenders, we want to see the 30 bottom products. They are slicing off 20% of our profits.
It is probably better to plot them in absolute values.
Negative margin values are plotted in red. For instance, you can plot a chart showing the positive margin contribution of the "good" items, and how this is partially or totally eaten up by the negative margin of the "bad" items.
The cumulate total of all plotted metrics should always be equal to 100%.
If the total margin is negative the total will converge to -100% rather than to 100%.
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, one chart at a time in the text box.
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.
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
You can choose one of the nine available color palettes. Six are inspired by Mekko Graphics, the other are default Tableau and PowerBi palettes, and a palette inspired from the IBCS examples. Red color for negative values does not change across palettes.
Avoids decorative use of colors. 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 .