5. Drag and drop the first cell to get cumulative percentages ready for all customers.
The data is all ready! It’s time we create the chart now.
6. Select the data (including headers).
7. Go to Insert Tab > Charts group > Recommended Charts
8. From the Insert Chart dialog box, go to the tab ‘All Charts’.
In Excel 2013, you do not see the option ‘Histogram’ on the left side. This is what makes the difference.
We will instead create a Combo chart (the closest to a Pareto chart).
9. From this list, select the chart type ‘Combo’.
10. For the Sales column, select a Clustered Column Chart.
11. For the Cumulative Percentage Column, select a Line Chart. Check the secondary axis.
Excel creates a chart, as shown below.
While it serves the purpose of a Pareto chart, you may edit it to bring it closer to a by-default Histogram chart.
We only need the cumulative percentage up to 100%.
1. Click on the axis > Format Axis pane > Axis options.
2. Adjust the maximum axis to 1.00 (100%).
The chart changes as follows:
Something still seems missing.
Maybe it’s the thickness of the clustered columns. But that’s not a problem – you can set it as desired.
1. Select clustered column chart > Click Format Data Series pane > Series options
2. Adjust the gap width (the gap between each column) to a lesser percentage.
We have set it to 5%.
The chart now looks like this.
That’s how you can make a very good-looking Pareto chart in older versions of Excel too.