Creating Pareto Chart Using Microsoft Excel : Part II

Now to create the chart. If you arrived at this post and have no idea why you're suddenly creating a chart, you may check the previous post on accumulating data first.

To continue, we're selecting the data for the chart. 

Choose B3:B7 and D3:D7 (Highlight B3:B7, press Ctrl, hightlight D3:D7). Then, choose Insert->Chart->Combo. Choose Series 2 as Secondary Axis. 

Now you have the Pareto chart. Customize by adding labels, values and changing the horizontal range.

Now that your chart is complete, you may begin analyzing the highest defects, problems or causes to plan the countermeasure.