If your frequencies are in a pivot table, insert a new sheet and copy the frequency table to the new location (the native Pareto chart in Excel is incompatible with pivot tables ).The steps to create the chart are slightly different for the desktop version and the web version of Microsoft Excel in Office 365. If you did not do the first part of the example, you can follow along from the following frequency table.
In the first part of the example, we took individual measurements and turned them into a frequency table.įrom there, you can create a Pareto chart in Excel with a cumulative percentage line. Now that you have a list of the categories and their frequencies, you can create a Pareto chart in Excel. Use the following steps to arrange the pivot table fields: One of the special features of pivot tables in Microsoft Excel is that you can use a column of data in multiple fields. If the data is not selected in the web version, you can select the data without any other clicks. Note: If the data is not selected in the desktop version, click the arrow next to Table/Range to select the data in the worksheet. Microsoft Excel should select all of the contiguous data.