Create Pareto Chart in Excel?

  • Thread starter Thread starter Tycon22
  • Start date Start date
T

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
 
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.
 
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. <
Click to expand...

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
 
If it's a list of text values, I've always used Pivot Tables to get the data
for the Pareto.
 
yo

Tycon22 said:
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
Click to expand...

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
 
Back
Top