Forum Discussion

excelhowto2023's avatar
excelhowto2023
Copper Contributor
May 17, 2025

step by step on how the excel template "Manufacturer defect analysis" is created

i would like to know the step by step on how the excel template "Manufacturer defect analysis" is created, i am just wondering how the bar chart is displaying in descending order but the data is not sorted, i would like to know how its done, thanks

1 Reply

  • It is a Pareto chart

    You'll find it on the Insert tab of the ribbon. 

    Click the 'Insert Statistics Chart' button in the Charts group and select the second chart under Histogram:

     

Resources