Pie Chart

 Pie Chart:

        Pie Chart is used to show proportions of a whole. Pie chart is used when the total of your numbers is 100%.

• To create a Pie Chart select your data in Excel worksheet.

• Go to insert tab ➤ charts group ➤ click on Pie Chart. 

• Select any 2D or 3D Pie

• Excel creates a pie chart for your data.

• Click on +icon on the right side of the chart to add chart elements (chart titles, data labels, legend)
• Click on chart title ➤ select above chart/ centered overlay.

• Click on + icon➤ click on Data Labels ➤select any one of them(center/inside end/outside end/best fit/data callout)

• Click on + icon➤ click on legend➤ select any one of them( right/top/ left/bottom)

• Click on the brush icon and select any style and color for your chart.

• Click on the funnel icon to add chart filters.

• Right click on the pie chart and click on format data labels.

• Format data labels➤ check on category name, percentage and uncheck the value and others.

• Now your chart looks like the below.

line chart

column chart