How To...Create a Pareto Chart in Excel 2003

[XemoXreignX]

Thank you SO much! You just saved a clueless Stats student's life!

[gathekei]

not 100 but from the max. frequency 68...sorry

[gathekei]

WELL i looks great but i was reading a book about tools of stadistisics for improving the quality from hitoshi kume and in pareto's chapter he build a chart similiar to u but in excel he used chart line- column not what u used and the line acumulated starts from 100 hundred not since 20 (the blue line)

[flying727]

Great job, this helped me finally complete a research project.

[digitalchimp]

This is a great demo. I found it very easy to follow your logic, and I thank you for taking the time to do this. Tony in San Francisco.

[queenyhood]

thank you very much.

[iluvgh3tt0princ3ss]

How do you do it in Excel for Mac 2008??? Please help!!!

[eoloughlin]

@iluvgh3tt0princ3ss - I have never used a Mac. Sorry!!!

[iluvgh3tt0princ3ss]

Thank you, very helpful !!

[Shaikah420]

NO sound in this :(

[Shaikah420]

@Shaikah420

Sorrrrrrry i restart my laptop and the there is sound

[Shaikah420]

No sound :(

[mpande2003]

Easily illustrated uing a Real Life Example. Perfect Explanation Thanks Sir

[Kruskot]

Hey I can understaind what you say. Speak more clear, please.

[neildeegan]

Thanks so much. This really helped. I'm doing an assignment for a course in NUIG. Thanks a lot.

[captainowow]

Although in 36+ years I was never asked to prepare such a chart, I recently was taking a class and they mentioned Pareto Chart. EOLOUGHLIN did a fine job.

Not sure what it means to me but at least I know HOW TO

[desmoface]

Thanks, very helpful.

[yamilams]

Very clear, very useful.... thanks a lot! ;-)

[theesnowman]

Thanks a lot! It clarified a bunch compared to other posts online. I did have trouble sorting my percent column since they had formulas such as (in your example) =B3/B14 = 1% or so, and so forth for B4, 5, 6, etc. When sorting I got a bunch of errors and large percentages that were obviously wrong. So I sorted the frequency first, then calculated the percentages.

[linuxBlob]

You forgot one step in your chart. A Pareto chart's first data plot along the second axis must coincide with the data height of the first axis. You need to set the first axis maximum to the total of your data to see this. So right mouse click on the Y-axis on the left and set the maximum to (TOTAL) and the minimum to 0. Now your line and bar chart for the first point should touch each other on one single point.

[ExKon3]

fuckin stat class making me do this shit, but prof never thought how to

[danubio9]

You save my life man!!! Thank youuu!!

[db0gdala]

Excellent!

[TimL1109]

This was extremely helpful!! Thank you so much!!

[rlanicek]

Thanks.

[brogaguy]

wow i need to submit my coursework this evening and finally my work is done!!

[lfemissile]

thank you so much!

[pitju]

thankyou!!! BIGUP!! Keepon makin' such good tutorials. It was pretty helpful!

[richerch]

This was very helpful, thank you!

[jfebarry]

Nice One