Dear All,
I need to create a concentration histogram chart, which tells, by each supplier cluster, the percentage of the total number of product it has.
I have available the following table:
Supplier | # Products |
---|
A | 200 |
B | 150 |
C | 105 |
D | 100 |
E | 90 |
F | 80 |
G | 70 |
I need to then cluster the suppliers due to its number of products. I mean: the first 1% suppliers (lets say only one in a total of 100 suppliers) is categorized as 'first 1%', the following falls in the 'from 1 to 20%' cluster and so on.
With so, I need to create the following chart:
Has someone eveer done something like this?