Forum Discussion
Pie of Pie chart keeps splitting one category into two
Help me out here guys, whenever I try to do pie of pie it keeps splitting my one data category of West Yorkshire into 2 sections. If I only select the West Yorkshire/Rest of Yorkshire data then it displays as it should do but without the Bradford/outside Bradford data (see the pie of pie in the top right). Then as soon as I try to add the Bradford/Outside Bradford stuff for pie #2 it splits the larger pie into 3 categories as below. Why is it doing this when I'm only giving it 4 values to play with? Changing the number of values in the plot doesn't help. Thanks for any advice you can give
2 Replies
Hi Marianne,
Sorry, i didn't catch what the is problem. Pie of pie is always split on of categories on sub ones. You may play by options with this. Please check this https://www.extendoffice.com/documents/excel/1442-excel-create-pie-of-pie-chart.html if helps.
is it possible to create one main pie segmented with the total values of sales. (Department A & B)
And to create from that pie chart, 1 more pies that has the segmentation of slow and fast employees in department A.
Thanks !
