# Pareto diagram with 2 X-axis

H.G. Lamy
Guest
Posts: n/a

 3rd Feb 2010
Hello,

for days I'm trying to make a Pareto chart to show the relative importance
of 77 products.
The best selling item makes already 15% of sales, the next best alone 12%
(both together consequently 27%), etc. etc.

The so-sorted 77 product names on the X-axis (low horizontal axis) are a
To ease up the chart's interpretation, I intend to additionally show a scale
of 0% to 100% on the second X-axis (top horizontal axis).

This scale should simply represent the share of the product count (which is
1/77 = 1,3% per item), in steps of 5% or 10% perhaps.

Is this feasable, and if so, how ?

Shane Devenshire
Guest
Posts: n/a

 5th Feb 2010
Hi,

Have you used the histogram tool? In 2003 and earlier you choose Tools,
Add-ins, Analysis ToolPak. Then you choose Tools, Data Analysis, Histogram,
fill in the dialog box as appropriate, checking Pareto (sorted histogram).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"H.G. Lamy" wrote:

> Hello,
>
> for days I'm trying to make a Pareto chart to show the relative importance
> of 77 products.
> The best selling item makes already 15% of sales, the next best alone 12%
> (both together consequently 27%), etc. etc.
>
> The so-sorted 77 product names on the X-axis (low horizontal axis) are a
> lot, and difficult to read.
> To ease up the chart's interpretation, I intend to additionally show a scale
> of 0% to 100% on the second X-axis (top horizontal axis).
>
> This scale should simply represent the share of the product count (which is
> 1/77 = 1,3% per item), in steps of 5% or 10% perhaps.
>
> Is this feasable, and if so, how ?
>
>
>
>
>
> .
>

H.G. Lamy
Guest
Posts: n/a

 9th Feb 2010
Shane,

far.
In the meantime, Jon Peltier in his PTS Blog also happened to offer several
possibilities the classical way.

Regards,

hgl
"Shane Devenshire" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hi,
>
> Have you used the histogram tool? In 2003 and earlier you choose Tools,
> Add-ins, Analysis ToolPak. Then you choose Tools, Data Analysis,
> Histogram,
> fill in the dialog box as appropriate, checking Pareto (sorted histogram).
>
> --
> If this helps, please click the Yes button.
>
> Cheers,
> Shane Devenshire
>
>
> "H.G. Lamy" wrote:
>
>> Hello,
>>
>> for days I'm trying to make a Pareto chart to show the relative
>> importance
>> of 77 products.
>> The best selling item makes already 15% of sales, the next best alone 12%
>> (both together consequently 27%), etc. etc.
>>
>> The so-sorted 77 product names on the X-axis (low horizontal axis) are a
>> lot, and difficult to read.
>> To ease up the chart's interpretation, I intend to additionally show a
>> scale
>> of 0% to 100% on the second X-axis (top horizontal axis).
>>
>> This scale should simply represent the share of the product count (which
>> is
>> 1/77 = 1,3% per item), in steps of 5% or 10% perhaps.
>>
>> Is this feasable, and if so, how ?
>>
>>
>>
>>
>>
>> .
>>

 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 Salmon Egg Storage Devices 3 7th Oct 2008 11:55 AM Mariam Microsoft Excel Charting 1 15th Sep 2008 06:03 PM Mariam Microsoft Excel Charting 0 15th Sep 2008 07:16 AM =?Utf-8?B?REQ=?= Microsoft Excel Programming 0 30th Oct 2006 04:07 PM =?Utf-8?B?UGFtTA==?= Microsoft Powerpoint 4 24th Mar 2005 06:55 AM

Features