Create and Customize a Pareto Chart in Microsoft Excel - - Windows Tips and Tricks with Geek

Wednesday, September 22, 2021

Create and Customize a Pareto Chart in Microsoft Excel

Pareto Chart in Excel

Create a Pareto Chart in Excel

For this how-to, we’ll use data for customer complaints. We have five categories for what our customers complained about and numbers for how many complaints were received for each category.

Start by selecting the data for your chart. The order in which your data resides in the cells is not important because the Pareto chart structures it automatically.

Go to the Insert tab and click the “Insert Statistical Chart” drop-down arrow. Select “Pareto” in the Histogram section of the menu. Remember, a Pareto chart is a sorted histogram chart.

On the Insert tab, click Statistical Charts, Pareto

And just like that, a Pareto chart pops into your spreadsheet. You’ll see your categories as the horizontal axis and your numbers as the vertical axis. On the right side of the chart are the percentages as the vertical secondary axis.

Pareto chart inserted into sheet

Now we can clearly see from this Pareto chart that we need to have some discussions about Price because that is our biggest customer complaint. And we can focus less on Support because we didn’t receive nearly as many complaints in that category.

Pareto chart

Customize a Pareto Chart

If you plan to share your chart with others, you might want to spruce it up a bit or add and remove elements from the chart.

You can start by changing the default Chart Title. Click the text box and add the title you want to use.

Click Chart Title to change it

On Windows, you’ll see helpful tools on the right when you select the chart. The first is for Chart Elements, so you can adjust gridlines, data labels, and the legend. The second is for Chart Styles, which lets you select a theme for the chart or a color scheme.

Adjust the Chart Elements

You can also select the chart and head to the Chart Design tab that displays. The ribbon provides you with tools to change the layout or style, add or remove chart elements, or adjust your data selection.

Chart Design tab ribbon

One more way to customize your Pareto chart is by double-clicking to open the Format Chart Area sidebar. You have tabs for Fill & Line, Effects, and Size & Properties. So, you can add a border, shadow, or specific height and width.

Format Chart area sidebar for the chart

You can also move your Pareto chart by dragging it or resize it by dragging inward or outward from a corner or edge.

Drag a corner or edge to resize a chart

No comments:

Post a Comment