Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to get a pareto diagram in excel | Charts and Charting in Excel | |||
Reversing only the vertical axis in a diagram | Excel Discussion (Misc queries) | |||
how to get a pareto diagram in excel | Charts and Charting in Excel | |||
how can i make pareto chart on 2 axis in excel? | Charts and Charting in Excel | |||
How can I add third axis to the diagram? | Charts and Charting in Excel |