Create Pareto Chart in Excel?

[Tycon22]

I was wondering if it was possible to create a pareto chart in excel? I
so, does anyone have a tutorial on how to do so? Thanks

 

[Barb Reinhardt]

You'll need the Analysis Toolpack to create Pareto Charts. Once installed,
run Data Analysis and choose Histogram. An option for the Histogram tool
is Pareto.

 

[Michael R Middleton]

Tycon22 -

I was wondering if it was possible to create a pareto chart in excel? If
so, does anyone have a tutorial on how to do so? Thanks. <

What is the format of the data? That is, is it a list of text values, or is
it already summarized in a sorted frequency distribution?

The Histogram tool has a Pareto option, but it's limited to summarizing
numerical values.

- Mike

www.mikemiddleton.com

 

[Barb Reinhardt]

If it's a list of text values, I've always used Pivot Tables to get the data
for the Pareto.

 

[Tandermar]

yo

I was wondering if it was possible to create a pareto chart in excel? I
so, does anyone have a tutorial on how to do so? Thanks

--
Tycon2
-----------------------------------------------------------------------
Tycon22's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1626
View this thread: http://www.excelforum.com/showthread.php?threadid=27698

I was looking for it too... It took me two days. I found this site now, it is having some stupid pareto drawer. it is not too pretty, but it did work for me
GL
huh, there is link :
http://qtcharts.com/index.php?g=prtt