Forum Discussion
how the bar chart is displaying in descending order but the data is not sorted
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,
Is there a trick to format the bar chart to display descending order without using a helper column?
not sure if the "Manufacturer defect analysis" template have custom add in
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:
