Sub divisions in a Pie Chart

[Jaiyana]

Hi,

I want to make a pie of pie chart containing Yes & No Responses with additional details about the Yes Response.



My result is 86% Yes and 14% No. Subdivision of Yes Response are 3%, 6% and 5%.



Now when I try to make pie of pie chart in Excel it changes to 75% No & 13% Yes with an additional space for subdivisions of Yes Response comprising of 12%.



This is not showing the correct result. How do I change it to 86% No Response & 14% Yes Response with another pie emerging from the Yes Response containing its subdivisions?

Thank you


Post Moved by Moderator


.

 

[Hui]

How about a Donut


or a Pie:

 

[Hui]

or again:

 

[NARAYANK991]

Hi ,

This is known as a pie of pie chart ; check out the following links for more details :

http://blog.davelevy.info/2010/12/16/pie-of-pie-in-excel/

http://www.criticaltosuccess.com/show-excel-pie-chart-details-with-an-exploded-bar-chart/

Narayan