Pareto chart
 

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

Pareto chart
 

On Feb 6, 12:13 am, wrote:
Hi...
how to create pareto chart? Is it easy?
It even hasnt be in excel, any free software?

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

Pareto chart
 

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
_______


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

Pareto chart
 

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)


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

Pareto chart
 

Ron -

Nice one.

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


"Ron Coderre" wrote in message
...
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)


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

Pareto chart
 

Thank you guys.

it works

Pareto chart
 

Thanks, Jon.

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

Best Regards,

Ron

"Jon Peltier" wrote in message
...
Ron -

Nice one.

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


"Ron Coderre" wrote in message
...
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)


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