Create a Pareto chart - Microsoft Support

Create a Pareto graph in Office 2016 to display data sorted into frequencies for further analysis. Pareto charts are especially effective in analyzing data ... Skiptomaincontent Officesupport Products Microsoft365 Office Outlook MicrosoftTeams OneDrive OneNote Windows MicrosoftEdge more... Devices Surface PCaccessories Mobile Xbox HoloLens Hardwarewarranties What'snew InstallOffice Account&billing Account MicrosoftStore&billing Templates Moresupport Communityforums Microsoft365Admins SmallBusinessAdmins Developer Education Reportasupportscam ExcelforMicrosoft365WordforMicrosoft365OutlookforMicrosoft365PowerPointforMicrosoft365ExcelforMicrosoft365forMacWordforMicrosoft365forMacOutlookforMicrosoft365forMacPowerPointforMicrosoft365forMacExcel2021Excel2021forMacExcel2019Word2019Outlook2019PowerPoint2019Excel2019forMacOutlook2019forMacExcel2016Word2016Outlook2016PowerPoint2016Excel2016forMacExcelforiPadExcelforiPhoneMore...Less AParetoorsortedhistogramchartcontainsbothcolumnssortedindescendingorderandalinerepresentingthecumulativetotalpercentage.Paretochartshighlightthebiggestfactorsinadataset,andareconsideredoneofthesevenbasictoolsofqualitycontrolasit'seasytoseethemostcommonproblemsorissues. WindowsmacOS CreateaParetochart Selectyourdata.Typically,youselectacolumncontainingtext(categories)andoneofnumbers.AParetochartthengroupsthesamecategoriesandsumsthecorrespondingnumbers. Ifyouselecttwocolumnsofnumbers,ratherthanoneofnumbersandoneofcorrespondingtextcategories,Excelwillchartyourdatainbins,justlikeahistogram.Youcanthenadjustthesebins. ClickInsert>InsertStatisticChart,andthenunderHistogram,pickPareto. YoucanalsousetheAllChartstabinRecommendedChartstocreateaParetochart(clickInsert>RecommendedCharts>AllChartstab. Tip: UsetheDesignandFormattabstocustomizethelookofyourchart.Ifyoudon'tseethesetabs,clickanywhereintheParetocharttoaddtheChartToolstotheribbon. Configurebins Right-clickonthecharthorizontalaxis,>FormatAxis>AxisOptions. UsetheinformationbelowtopicktheoptionsyouwantintheFormatAxistaskpane. ByCategory   Thedefaultwhenbothdataandtextareplotted.Thetextcategoriesareplottedonthehorizontalaxisandgraphedindescendingorder. Tip: Tocountthenumberofappearancesfortextstrings,addacolumnandfillitwiththevalue“1”,thenplottheParetochartandsetthebinstoByCategory. Automatic   ThisisthedefaultforParetochartsplottedwithasinglecolumnofdata.ThebinwidthiscalculatedusingScott’snormalreferencerule. Binwidth   Enterapositivedecimalnumberforthenumberofdatapointsineachrange. Numberofbins   EnterthenumberofbinsfortheParetochart(includingtheoverflowandunderflowbins).Thebinwidthwilladjustautomatically. Overflowbin   Checktheboxtocreateabinforallvaluesabovethenumberinthecorrespondingbox.Tochangethisvalue,enteradecimalnumberintothebox. Underflowbin   Checktheboxtocreateabinforallvaluesbeloworequaltothenumberinthecorrespondingbox.Tochangethisvalue,enteradecimalnumberintothebox. FormulasusedtocreatehistogramsinExcel2016 Scott’snormalreferencerule:    Scott’snormalreferenceruletriestominimizethebiasinvarianceoftheParetochartcomparedwiththedataset,whileassumingnormallydistributeddata. OverflowBin    UnderflowBin    CreateaParetochart Selectyourdata.Typically,youselectacolumncontainingtext(categories)andoneofnumbers.AParetochartthengroupsthesamecategoriesandsumsthecorrespondingnumbers. Ifyouselecttwocolumnsofnumbers,ratherthanoneofnumbersandoneofcorrespondingtextcategories,Excelwillchartyourdatainbins,justlikeahistogram.Youcanthenadjustthesebins.Fordetails,see"Configurebins"ontheWindowstab. Ontheribbon,clicktheInserttab,andthenclick(theStatisticalcharticon),andinHistogramsection,clickPareto. Tip: UsetheChartDesignandFormattabstocustomizethelookofyourchart.Ifyoudon'tseethesetabs,clickanywhereintheParetocharttodisplaythemontheribbon. SeeAlso Createawaterfallchart Createahistogram Createaboxandwhiskerchart CreateatreemapchartinOffice CreateasunburstchartinOffice Needmorehelp? Expandyourskills ExploreTraining Getnewfeaturesfirst JoinMicrosoftOfficeInsiders Wasthisinformationhelpful? Yes No Thankyou!Anymorefeedback?(Themoreyoutellusthemorewecanhelp.) Canyouhelpusimprove?(Themoreyoutellusthemorewecanhelp.) Whataffectedyourexperience? Resolvedmyissue Clearinstructions Easytofollow Nojargon Pictureshelped Other Didn'tmatchmyscreen Incorrectinstructions Tootechnical Notenoughinformation Notenoughpictures Other Anyadditionalfeedback?(Optional) Submitfeedback Thankyouforyourfeedback! ×