— The workbook related to this solution can be downloaded from Solution – Challenge 21 – Male Female Pie Chart with Pictures —
Below is a possible solution to the challenge – Challenge 21 – Male Female Pie Chart with Pictures
Download the files related to this challenge as given in the problem –
Male_Female_Pie_Chart Excel File | Male Picture -1st Pie | Female Picture – 1st Pie
Male Parliamentarian – 2nd Pie | Female Parliamentarian – 2nd Pie | Parliament – 2nd Pie
First Pie Chart
1. Create a Pie Chart on the data.
2. Drag the pies apart by double clicking one pie which creates a gap between two pie slices.
3. Delete the Legends (M / F)
4. Changed the title to "Parliament Representation" and make Font Bold and White.
5. Fill the title box with appropriate Green color.
6. Right click > Format Chart Title > Format it with Soft Edge (2.5 points)
7. Double click on one pie and give it appropriate Glow. Do the same with other pie.
8. Select the chart > Design Menu > Add Chart Element > Data Lables > Center. Now format the number (%age) appropriately in White and Bold.
9. Select the chart and Insert > Picture > Female_Small.png and do the same for Male_Small.png
10. Adjust the placements of Male and Female pictures.
You now get the pie which you want.
Second Pie Chart
1. Repeat steps 1 to 8 as in First Pie Chart instructions.
2. Select the chart and Insert > Picture > Male_Parliament.png and do the same for Female_Parliament.png and Parliament.png
3. Adjust the placement of all 3 pictures.
You now get the pie which you want.
