How to make a pareto chart in excel 2016 mac
In order to create a pareto chart in Excel 2016 Mac, first open the Excel window and select the data that you want to graph. Next, Click on the Insert/Chart tab and then selecting Pareto Charts from the dropdown list. On the next window, you will be asked how many categories you want to display on your chart. Select either 20 or 30 as whichever number better meets your needs. Finally, click on OK button to continue with creating your pareto chart.