View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
H.G. Lamy H.G. Lamy is offline
external usenet poster
 
Posts: 48
Default Pareto diagram with 2 X-axis

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