SOLVED

pie chart to show multilevel shareholder ownership

%3CLINGO-SUB%20id%3D%22lingo-sub-2904857%22%20slang%3D%22en-US%22%3Epie%20chart%20to%20show%20multilevel%20shareholder%20ownership%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904857%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20pie%20chart%20(or%20sunburst%20or%20donut%20chart)%20to%20represent%20ownership%20in%20a%20company%20where%20there%20is%20a%20multilevel%20shareholder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efirst%20layer%3C%2FP%3E%3CP%3E%5Bcompany%20name%5D%3C%2FP%3E%3CP%3Eshareholder%20a%20has%2050%25%3C%2FP%3E%3CP%3Eshareholder%20b%20has%2025%25%3C%2FP%3E%3CP%3Eshareholder%20c%20has%2025%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esecond%20layer%3C%2FP%3E%3CP%3Eshareholder%20a%20is%20also%20a%20company%20and%20has%20the%20following%20shareholder%3C%2FP%3E%3CP%3Eshareholder%20a1%20has%2050%25%3C%2FP%3E%3CP%3Eshareholder%20a1%20has%2010%25%3C%2FP%3E%3CP%3Eshareholder%20a1%20has%2010%25%3C%2FP%3E%3CP%3Eshareholder%20a1%20has%2015%25%3C%2FP%3E%3CP%3Eshareholder%20a1%20has%2015%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eshareholder%20b%20is%20also%20a%20company%26nbsp%3B%20has%20the%20following%20shareholder%3C%2FP%3E%3CP%3Eshareholder%20b1%20has%2040%25%3C%2FP%3E%3CP%3Eshareholder%20b1%20has%2020%25%3C%2FP%3E%3CP%3Eshareholder%20b1%20has%2020%25%3C%2FP%3E%3CP%3Eshareholder%20b1%20has%2020%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eshareholder%20c%20is%20a%20person%20so%20no%20further%20breakdown%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20shareholder%20a1%20is%20also%20a%20company%20and%20needs%20to%20also%20break%20down%20into%20the%20third%20layer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20suggest%20how%20to%20structure%20a%20data%20and%20step%20by%20step%20on%20how%20to%20do%20this%2C%20thanks%20(I%20have%20been%20trying%20to%20search%20in%20youtube%20for%20this%20but%20can%20find%20the%20solution.%20thanks%20for%20all%20the%20help.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2904857%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905002%22%20slang%3D%22en-US%22%3ERe%3A%20pie%20chart%20to%20show%20multilevel%20shareholder%20ownership%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201078%22%20target%3D%22_blank%22%3E%40paarks%3C%2FA%3E%26nbsp%3BPerhaps%20a%20donut%20like%20in%20the%20attached%20file%3F%20Personally%2C%20I%20don't%20like%20these%20types%20of%20charts.%20It%20becomes%20cluttered%20very%20easily%20and%20ofter%20too%20colourful.%20Removed%20all%20the%20colour%20to%20keep%20the%20formatting%20at%20a%20minimum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20that%20you%20have%20to%20express%20the%20holding%20of%20a%20sub-shareholder%20as%20a%20percentage%20of%20the%20total.%20So%2C%20when%20%22a1%22%20holds%2050%25%20of%20%22a%22%2C%20which%20in%20turn%20holds%2050%25%20of%20the%20total%2C%20%22a1's%22%20share%20is%2025%25%20of%20the%20total.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a pie chart (or sunburst or donut chart) to represent ownership in a company where there is a multilevel shareholder.

 

first layer

[company name]

shareholder a has 50%

shareholder b has 25%

shareholder c has 25%

 

second layer

shareholder a is also a company and has the following shareholder

shareholder a1 has 50%

shareholder a1 has 10%

shareholder a1 has 10%

shareholder a1 has 15%

shareholder a1 has 15%

 

shareholder b is also a company  has the following shareholder

shareholder b1 has 40%

shareholder b1 has 20%

shareholder b1 has 20%

shareholder b1 has 20%

 

shareholder c is a person so no further breakdown

 

then shareholder a1 is also a company and needs to also break down into the third layer.

 

 

 

please suggest how to structure a data and step by step on how to do this, thanks (I have been trying to search in youtube for this but can find the solution. thanks for all the help.)

 

 

 

3 Replies
best response confirmed by paarks (New Contributor)
Solution

@paarks Perhaps a donut like in the attached file? Personally, I don't like these types of charts. It becomes cluttered very easily and ofter too colourful. Removed all the colour to keep the formatting at a minimum.

 

Note that you have to express the holding of a sub-shareholder as a percentage of the total. So, when "a1" holds 50% of "a", which in turn holds 50% of the total, "a1's" share is 25% of the total.

 

@Riny_van_Eekelen thank you so much for this guideline, I will try to work on this.

Anyway, you also mentioned that you don't like this kind of chart, maybe you have a better idea of what chart I should use to present this info. I totally welcome your advice, thanks in advance.

@paarks Can't really think of an alternative. It's no more than personal dislike. Pie charts take a lot of space and are not very clear if you have more than four or five slices.