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:
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?