# how do you create a Pareto Chart

=?Utf-8?B?a3RkdTQ=?=
Guest
Posts: n/a

 5th Mar 2006
I'm having a lot of difficulty in constructing a Pareto Chart. I don't
understand what the bin range is.

Michael R Middleton
Guest
Posts: n/a

 5th Mar 2006
ktdu4 -

> I'm having a lot of difficulty in constructing a Pareto Chart. I don't
> understand what the bin range is. <

If you're referring to the Histogram tool of Excel's Analysis ToolPak, the
data in the Input Range must be numerical values on the worksheet, and the
Bin Range must be numerical values on the worksheet in ascending order that
specify the upper limit of each interval for the frequency distribution. The
Pareto option sorts the intervals according to frequencies. This option of
the Histogram tool does not create a typical Pareto chart.

The usual Pareto chart shows frequencies for text labels, not numerical
values. The Histogram tool is not useful for preparing a standard Pareto
chart. Instead, if your raw data are a list of text labels on the worksheet,
use a Pivot Chart to obtain the frequencies, and use a Column chart type to
prepare the Pareto chart.

- Mike
www.mikemiddleton.com

=?Utf-8?B?a3RkdTQ=?=
Guest
Posts: n/a

 5th Mar 2006
thank you.

This helped me a lot. I was able to finally get it to work.

Katie

"Michael R Middleton" wrote:

> ktdu4 -
>
> > I'm having a lot of difficulty in constructing a Pareto Chart. I don't
> > understand what the bin range is. <

>
> If you're referring to the Histogram tool of Excel's Analysis ToolPak, the
> data in the Input Range must be numerical values on the worksheet, and the
> Bin Range must be numerical values on the worksheet in ascending order that
> specify the upper limit of each interval for the frequency distribution. The
> Pareto option sorts the intervals according to frequencies. This option of
> the Histogram tool does not create a typical Pareto chart.
>
> The usual Pareto chart shows frequencies for text labels, not numerical
> values. The Histogram tool is not useful for preparing a standard Pareto
> chart. Instead, if your raw data are a list of text labels on the worksheet,
> use a Pivot Chart to obtain the frequencies, and use a Column chart type to
> prepare the Pareto chart.
>
> - Mike
> www.mikemiddleton.com
>
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Tycon22 Microsoft Excel Charting 4 5th Jan 2008 11:58 PM =?Utf-8?B?Qm9iIEQu?= Microsoft Access 1 13th Nov 2004 05:27 PM Tycon22 Microsoft Excel Charting 1 13th Nov 2004 12:54 AM Jim Moore Microsoft Access Forms 3 5th Nov 2003 01:12 PM Jim Moore Microsoft Access Forms 4 3rd Nov 2003 03:09 PM

Features