View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Pareto diagram with 2 X-axis

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 ?

Thank you in advance




.