Anyone familar with Pareto charts and Excel??

[Squeak 17]

I need some assistance making one ?

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?

[GTAVercetti 0]

I am familiar with both separately, but not together.

I bet google can help.

Then again, a pareto chart is just a fancy bar graph that is ordered highest to lowest with a percent line at the top (not really needed in my opinion). Excel has a chart wizard that can build the bar graph. I bet it can make a concurrent line graph as well.

In fact, here is some info on it (scroll down for pareto chart)

http://www.qualitydigest.com/oct97/html/excel.html

Why yes, my license number is a palindrome. Thank you for noticing.

[2fat2fly 0]

I'm sorry. Nah, chart wizard will lay out the chart for you-getting the data is the tough part. Gimme a yell if you get to any sticking points.

I am not the man. But the man knows my name...and he's worried

[IanHarrop 43]

Quote

I need some assistance making one ?

I found this

http://personnel.ky.gov/NR/rdonlyres/D04B5458-97EB-4A02-BDE1-99FC31490151/0/ParetoChart.pdf

and

http://www.smartteaching.org/topics/37_pce.pdf

"Where troubles melt like lemon drops, away above the chimney tops, that's where you'll find me" Dorothy

[Squeak 17]

Thanks Everyone I got it sorted I was reluctant to click on thr "KY" link Ian But it's the one that worked for me.
I was trying to do it in the Analysis tools section of Excel and kept getting errors, the KY link allowed me to do it manually Thanks

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?

[2fat2fly 0]

Quote

the KY link allowed me to do it manually Thanks

That's what a lot of people use it for.

I am not the man. But the man knows my name...and he's worried

[sunshine 2]

no

___________________________________________
meow

I get a Mike hug! I get a Mike hug!

[Unstable 9]

I made this for a class not too long ago. If you use "R" this is the onlly way I know how to make a pareto chart. This should also be matlab compatible.

=========Shaun ==========