How To Use Excel Pie Chart

There are many different parts to a chart in excel such as the plot area that contains the pie chart representing the selected data series the legend and the chart title and labels.

How to use excel pie chart. On top of that it s easy to make. Select the data you will create a pie chart based on click insert insert pie or doughnut chart pie. Click the button on the right side of the chart and click the check box next to data labels. Please do as follows to create a pie chart and show percentage in the pie slices. Click the legend at the bottom and press delete.

3 d pie uses a three dimensional pie chart that displays color. Click the pie chart icon. Select the pie chart. Pie charts are difficult to draw as they present the relative value of some particular data as value or as a percentage in a circular graph. With the help of excel the graphical analysis of pie charts has become popular and easier.

In this article i am going to demonstrate how to make a pie chart in excel. All these parts are separate objects and each can be formatted separately. What s good about pie charts. Then a pie chart is created. You ll see several options appear in a drop down menu.

2 d pie create a simple pie chart that displays color coded sections of your data. Each section looks like a slice of a pie and represents a category. Excel pie charts are useful to display fractions of a whole by splitting a circle into sections. While most of the charts in excel are easy to create pie charts are even easier. Create a pie of pie or bar of pie chart in excel a pie of pie or bar of pie chart it can separate the tiny slices from the main pie chart and display them in an additional pie or stacked bar chart as shown in the following screenshot so you can see the smaller slices more visible or easier.

Create the pie chart repeat steps 2 3. You don t need to worry a lot about customization as most of the times the default settings are good enough. Click on the first chart and then hold the ctrl key as you click on each of the other charts to select them all. Click the paintbrush icon on the right side of the chart and change the color scheme of the pie chart. Such layout makes it easy to observe relationships between parts but the smaller becomes the slice less than 10 the harder becomes to estimate it visually.