How to create simple '2-D and 3-D Pie Chart' using 'Excel'

How to create simple 2-D and 3-D Pie Chart using Excel

1.Creating 2-D Pie Chart:

• For creating chart we need data in excel, so consider below data having , Male count is in cell ‘B2’ and Female count in cell ‘C2’ as below:

• Select the rows whose Pie Chart you want to create, for example here we select header  ‘B1’ and ‘C1’ as same will reflect as headers or legends in the graph and also select row with cells ‘B2’ and ‘C2’ as it contain required  chart data:

• With these rows selected, click ‘Insert’:

• Then under ‘Recommended Charts’ select arrow of circular shape:

   

•     Under ‘2-D Pie’ select the type of chart you want:

•  And your 2-D Pie Chart is created, showing Legends ‘Male’ and ‘Female’
•  If you hover with mouse on the chart, you can also find percentage of that data as well:

 

 

 

2. Creating 3-D Pie Chart:

• Similarly we can create 3-D Pie Chart, consider below data of age groups, from cells ‘B23’ till ‘E23’ which depicts age group from ‘Age 0-14’, ‘Age 15-64’, ’Age 60-64’, and ‘Age 65+’ out of the total population:       

          

 

•     Select the rows whose chart  you want to create, for example here we select header from  ‘B22’ till ‘E22’ as same reflect as legend/headers in the chart, and also select row from cell ‘B23’ till ‘E23’ as they contain required chart data:

•      With these rows selected, click ‘Insert’:

 

• Then under ‘Recommended Charts’ select arrow of circular shape:

 

•      Select ‘3-D Pie’:

•     And your 3-D Pie Chart is created, showing legends ‘Age 0-14’, ‘Age 15-64’, ’Age 60-64’, and ‘Age 65+’
•     If you hover with mouse on chart, you can also find percentage of that data as well:

 

•      Make this more attractive, by clicking on the chart and select the look and feel you want:

•       And its done:

 

•      Double click on ‘Chart Title’ and rename it as required, like below: