Pareto Diagramm Excel 2016. 10 right click on any of the bars in your chart and click change series chart type from the pop up menu list. And the change chart type dialog box will open.
Select the range a3 b13. 11 choose line with markers type under cumulative series. Enter a chart title.
Select your data filled table and select recommended charts under the insert menu.
Click the button on the right side of the chart and click the. To customize the theme of your pareto chart go to chart tools menu and. 9 so the created chart will be. 13 right click on the cumulative sales series bar in your.