How To Use Excel Pie Chart

Combine pie chart into a single figure.

How to use excel pie chart. Please do as follows to create a pie chart and show percentage in the pie slices. The pie chart is commonly used and for good reason. Another reason that you may want to combine the pie charts is so that you can move and resize them as one. It presents data efficiently shows both values and proportions and is very easy to read. Let s start with the good things first.

Click the paintbrush icon on the right side of the chart and change the color scheme of the pie chart. With the help of excel the graphical analysis of pie charts has become popular and easier. Select the data you will create a pie chart based on click insert insert pie or doughnut chart pie. Then a pie chart is created. Excel pie charts are useful to display fractions of a whole by splitting a circle into sections.

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. Click the button on the right side of the chart and click the check box next to data labels. Add data labels to the pie chart. Click format group group. Click the legend at the bottom and press delete.

Let s go through the pros and cons of using pie charts in excel. In this article i am going to demonstrate how to make a pie chart in excel. 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. Select the pie chart. 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. While most of the charts in excel are easy to create pie charts are even easier. It s one of the best excel charts you can use. 2 d pie create a simple pie chart that displays color coded sections of your data. All pie charts are now combined as one figure.