Excel 2016 or later · 1. Select the range A3:B13. Pareto Chart Data in Excel · 2. On the Insert tab, in the Charts group, click the Histogram symbol. Insert Pareto Chart.ParetoChart Excel2016orlater|AllVersionsThisexampleteachesyouhowtocreateaParetochartinExcel.TheParetoprinciplestatesthat,formanyevents,roughly80%oftheeffectscomefrom20%ofthecauses.Inthisexample,wewillseethatroughly80%ofthecomplaintscomefrom20%ofthecomplainttypes.Excel2016orlaterTocreateaParetochartinExcel2016orlater,executethefollowingsteps.1.SelecttherangeA3:B13.2.OntheInserttab,intheChartsgroup,clicktheHistogramsymbol.3.ClickPareto.Result:Note:aParetochartcombinesacolumnchartandalinegraph.4.Enteracharttitle.5.Clickthe+buttonontherightsideofthechartandclickthecheckboxnexttoDataLabels.Result:Conclusion:theorangeParetolineshowsthat(789+621)/1722≈80%ofthecomplaintscomefrom2outof10=20%ofthecomplainttypes(OverpricedandSmallportions).Inotherwords:theParetoprincipleapplies.AllVersionsIfyoudon'thaveExcel2016orlater,simplycreateaParetochartbycombiningacolumnchartandalinegraph.ThismethodworkswithallversionsofExcel.1.First,selectanumberincolumnB.2.Next,sortyourdataindescendingorder.OntheDatatab,intheSort&Filtergroup,clickZA.3.Calculatethecumulativecount.EntertheformulashownbelowintocellC5anddragtheformuladown.4.Calculatethecumulative%.EntertheformulashownbelowintocellD4anddragtheformuladown.Note:cellC13containsthetotalnumberofcomplaints.Whenwedragthisformuladown,theabsolutereference($C$13)staysthesame,whiletherelativereference(C4)changestoC5,C6,C7,etc.5.SelectthedataincolumnA,BandD.Toachievethis,holddownCTRLandselecteachrange.6.OntheInserttab,intheChartsgroup,clicktheColumnsymbol.7.ClickClusteredColumn.8.Rightclickontheorangebars(Cumulative%)andclickChangeSeriesChartType...TheChangeChartTypedialogboxappears.9.FortheCumulative%series,chooseLinewithMarkersasthecharttype.10.PlottheCumulative%seriesonthesecondaryaxis.11.ClickOK.Note:Excel2010doesnotoffercombochartasoneofthebuilt-incharttypes.Ifyou'reusingExcel201