petit_bateau
Active Member
Given that you are breaking down the supply by OEM and supplier, you may want to consider a mosaic chart (Mosaic plot - Wikipedia). This would make is easier to see how for example LG is a key supplier to each OEM and how that fraction from LG varies by client.
jhm, My previous answer to you was incorrect. My apologies. I now appreciate there is a difference between a Mosaic chart and a Navajo blanket chart. The mosaic plot is not specifically catered for in excel but as usual Peltier covers how to create one at Marimekko Charts - Peltier Tech Blog where it seems they are also called Marimekko charts, so both have alternate textile names I will have a look at this further if I get time. Once again my apologies.