I have a table for which I want to create a pie chart with a further breakout of a single segment to show additional detail.
A sample spreadsheet is attached.
Ideally the purple that's displaying as 'Other' in the chart would be titled 'Central' and the breakout bar on the right would have 4 sections corresponding to the 'Child', 'Other', 'Mother' and 'Interim' that compose the 'Central' pie segment.
How can the data be setup differently to attain this result? Am I missing something in the chart settings or data selection?
Secondly, is it possible to have breakouts on two of the larger pie segments on one graph?
I'd be appreciative of any help.