Pareto chart

[sekr...@gmail.com]

Hi...
how to create pareto chart? Is it easy?
It even hasnt be in excel, any free software?

[stova...@gmail.com]

Hi,
please check online charts generator on www.qtcharts.com . there is
also pareto generator
gl
stovar

[Jon Peltier]

To make a pareto chart, sort your data in descending order of the numerical
value (counts, instances, whatever), then make a column chart. If you want
the line showing cumulative amounts, in the next column use a formula to
construct a running sum*, add that to the chart (it will first be another
set of columns), select it, go to the Chart menu > Chart Type, and choose a
line type.

*for a running sum, suppose your labels are in cells A2:A10, your numbers
are in B2:B10. Select C2, enter this formula:

=sum(C$2:C2)

Copy this down to fill C2 through C8

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

<sekr...@gmail.com> wrote in message
news:0199f99d-f42d-4b6b...@z17g2000hsg.googlegroups.com...

[Ron Coderre]

For a description:
http://en.wikipedia.org/wiki/Pareto_chart

For a working Excel model that will plot your data
see the Pareto Plotter at this website:
http://www.contextures.com/excelfiles.html#Charts

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

<sekr...@gmail.com> wrote in message
news:0199f99d-f42d-4b6b...@z17g2000hsg.googlegroups.com...

[Jon Peltier]

Ron -

Nice one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Ron Coderre" <ronREMOVET...@bigfoot.com> wrote in message
news:uEgW2lF...@TK2MSFTNGP02.phx.gbl...

[sekr...@gmail.com]

Thank you guys.

it works

[Ron Coderre]

Thanks, Jon.

--------------------------

Best Regards,

Ron

"Jon Peltier" <jonxl...@SPAMpeltiertech.com> wrote in message
news:e6vzKyGa...@TK2MSFTNGP02.phx.gbl...