Sorting in Microsoft Excel .xls - I want to create a Pareto Chart
Howdy,
This is a Microsoft Excel Problem. I want to create a Pareto Chart and I have data in this form
Cause: Frequency
Cause 1: 10
Cause 2: 30
Cause 3: 5
Cause 4: 40
I want to create a sort on that and get the data in this form
Cause: Frequency
Cause 4: 40
Cause 2: 30
Cause 1: 10
Cause 3: 5
I am sure there must be some way in excel to do that, just using sort doesnt work because it sorts only the frequency and the other column remains the same.
I'm using Excel 2003, but the method should be at least approximately the same for earlier versions:
1) Select both columns
2) Click on Data (on the "standard" tool bar), then Sort
3) In the resulting dialog box, choose the option at the top (Sort By...) and select the column where the frequency data appears in the drop-down box (let's say it's B in this example), then select Descending and click "OK."
The data should be sorted as you want it. Post back if you still have trouble.
__________________
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.-- Joseph Heller
For those using Excel 2003 or >, there is a histogram maker inside the "Data Analysis" add-in. A little goofy until you get used to it, but is pretty handy, especially since it lets you specify your own custom bins.
Sorting in Microsoft Excel .xls - I want to create a Pareto Chart
Linear Mode
