A
A
Anton Mikhailov2014-06-20 09:13:40
infographics
Anton Mikhailov, 2014-06-20 09:13:40

How to create a nested Pie Chart in Excel?

The task is to split the pie chart in Excel in such a way that the percentage inside the already divided shares is also displayed. That is, it turns out, as it were, "a share of a share." For example, we have companies in the general set engaged in woodworking (such 40%) and metal processing (60%). Of the 40% of woodworking companies, it is necessary to choose the share of companies that have the latest equipment of N firm installed (let 20% have it installed, and 80% not). Well, let's say 35% of the metalworkers use the equipment of the company M, and 65% do not use it. The picture should be something like:
i011.radikal.ru/1406/eb/24a4613a3b60.jpg
Similar questions are found on the Internet, but I did not find a solution

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
RomanAkaMagician, 2014-06-20
@RomanAkaMagician

This is called a secondary pie chart. Read for example:
office.microsoft.com/en-us/excel-help/HA010211848.aspx

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question