Pie Charts in Excel

What are Pie Charts in Excel?

A proto-indo european chart is a round representation that reflects the numbers of a single row or single column of Excel. The individual numbers are called data points ( or categories ) and a tilt ( row or column ) of numbers is called a data series. Every pie graph consists of slices ( or parts ), which when added make a complete proto-indo european ( or circle ) .
For exemplar, the following image shows some proto-indo european charts of Excel. On the exceed, the three-d pie chart is to the leave and the Pie of Pie chart is to the right. At the bottom, the Bar of Pie chart is to the left and the Doughnut chart is to the right .
Make Pie Chart in Excel
You are spare to use this image on your web site, templates, etc, Please provide us with an attribution linkHow to Provide Attribution ? Article Link to be Hyperlinked
For eg :
beginning : Pie Charts in Excel ( wallstreetmojo.com )
The purpose of making a pie chart in Excel is to visualize data when there are a few data points. furthermore, all the datum points should belong to a specific time period. A pie chart is not desirable when there are many data points or the datum points pertain to different time periods.

How to Make a Pie Chart in Excel?

Excel has different varieties of proto-indo european charts. In this article, we will learn to make the follow pie charts :

  1. 2-D pie chart
  2. 3-D pie chart
  3. Pie of Pie chart
  4. Bar of Pie chart
  5. Doughnut chart

Let us create each Excel pie graph one by one with the avail of examples .

2-D Pie Chart

A 2-D ( two-dimensional ) proto-indo european chart is frequently used in Excel. It is a standard proto-indo european chart that displays one cut for each datum sharpen. The bigger the count ( or data steer ) represented by the piece, the larger the sphere under it .

Example #1

The take after prototype shows the quantities sold ( column B ) of seven different flavors ( column A ) of a beverage. All the flavors of this beverage are manufactured by an arrangement. We want to perform the stick to tasks :

  1. Make a 2-D pie chart in Excel by taking into account the given dataset. Interpret the pie chart thus created.
  2. Add data labels and data callouts to the pie chart.
  3. Separate a few slices from the pie (or circle) and show how to change their color.
  4. Rotate the slices and increase the gap between them.
  5. Change the chart style and show how to apply filters to the pie chart in excel.

eminence that the numbers pertain to a specific clock time menstruation .
Pie Chart Example 1
The tasks and the correspond steps to be performed are listed as follows :
Task a: Make a 2-D pie chart and interpret it
Step 1: Select the stallion dataset ( A1 : B8 ). adjacent, click the proto-indo european chart icon from the “ charts ” group of the Insert check. Select a 2-D proto-indo european chart .
The selections are shown in the following image .
Make a Pie Chart Excel Example 1-1
Step 2: A 2-D proto-indo european chart is inserted in Excel. This is shown in the follow effigy .
Notice that the subtitle ( on top ) and the caption ( at the bottom ) are automatically added to the chart. The subtitle of the chart is the like as the head of column B. The legend reflects all the flavors of column A .
Pie Chart Example 1-2
Interpretation of the 2-D pie chart: Each cut of the chart displays the issue of beverages sold in a particular time period. One slice represents one season of the beverage. When all the slices are added, a complete pie is obtained. so, the stallion proto-indo european represents the entire of column B, which is 3130 .
watch that the slice of mango ( orange colored ) is the biggest, while that of papaya ( green colored ) is the smallest. This is because the sales of mango ( 650 ) are the maximum and that of papaya ( 200 ) are the least. The moment highest sales are of the strawberry season ( 580 ) .
Hence, one can interpret that the mango relish of the beverage has the highest demand. In contrast, the papaya flavor is not a lot preferred by the customers of the administration .
Task b: Add data labels and data callouts
Step 3: Right-click the proto-indo european chart and expand the “ add data labels ” option. following, choose “ add data labels ” again, as shown in the follow double .
Pie Chart Example 1-3
Step 4: The datum labels are added to the chart, as shown in the following visualize. With these labels, the sales measure of each season is displayed on the respective slit. therefore, data labels make it easy to read and interpret an excel proto-indo european chart .
Note: Data labels are directly linked to the datum points of the reference dataset. therefore, the data labels mechanically update with a change in the datum points .
Pie Chart Example 1-4
Step 5: Right-click the pie chart again. Click the arrow of “ add data labels ” and blue-ribbon “ add data callouts. ” The datum callouts have been added in the follow persona .
Notice that each slice shows the name of the season along with its share in the integral pie. Since the parcel is in percentage, a glance at the pie chart can suggest the highly favored and the less preferable flavors. The full of the proto-indo european is 100 % .
Pie Chart Example 1-4
Task c: Separate the slices from the pie (or circle) and show how to change their color
Step 6: Select the slice to be separated and drag it away from the proto-indo european with the aid of the mouse pointer. In the pursuit image, the slices having the utmost ( orange colored ) and the minimum sales ( green colored ) have been separated from the proto-indo european .
Note: To join the slices to the pie again, drag them back to their position. alternatively, press the unmake shortcut “ Ctrl+Z. ”
Pie Chart Example 1-6
Step 7: Double-click the slice whose color is to be changed. future, right-click it and select the option “ format data point ” from the context menu. This option is shown in the trace persona .
Pie Chart Example 1-7
Step 8: The “ format data point ” paneling opens, as shown in the take after effigy. In the “ fill ” tab key, the “ automatic ” and “ change colors by slice ” options are selected by default option .
If the “ color ” choice is visible ( shown within the bolshevik box ), select the hope color from it. If the “ color ” option is not visible, choose “ firm satiate ” and then choose the hope color. Next, close the “ format data detail ” pane .
The selected color will be applied to the slice that was double-clicked in the preceding step .
Note: One can highlight the crucial slices and put dull colors to the remaining ones. thus, the small and non-relevant slices can be filled with lighter colors. This helps focus on particular datum points .
Pie Chart Example 1-8
Task d: Rotate the slices and increase the gap between them
Step 9: Select the pie graph and right-click it. Choose “ format data series ” from the context menu. This choice is shown in the following image .
Pie Chart Example 1-9
Step 10: The “ format data series ” paneling opens, as shown in the follow picture. In the “ series options ” tab, perform the postdate actions :

  • In “angle of first slice,” enter 96◦ (96 degrees).
  • In “pie explosion,” enter 18% (18 percent).

adjacent, close the “ format data series ” acid .
Pie Chart Example 1-10
Step 11: The slices of the pie have been rotated. furthermore, the break between them has been increased. This is shown in the follow visualize .
Notice that the entire proto-indo european has been rotated. therefore, the slice that was earlier on the top-right has moved to the bottom-right. however, the colors of the slices have not been impacted .
Pie Chart Example 1-11
Task e: Change the chart style and show how to apply filters to the pie chart
Step 12: Click the proto-indo european chart. Three icons will appear on the top-right side of the chart. adjacent, perform the following actions :

  • Click the “chart styles” button or the paintbrush icon.
  • Select the desired style from the “style” tab.

Notice the change chart dash in the come double .
When the cursor is hovered over the different graph styles, a preview is shown in Excel. so, the preview helps see the way the pie chart would look if the respective stylus is selected .
Pie Chart Example 1-12
Step 13: Click the “ chart filters ” push button ( or the filter icon ) displayed on the top-right side of the chart .
In the “ values ” pill ( shown in the succeed image ), all the flavors of the beverage are shown under “ categories. ” The individual column ( column B ) used to create the excel pie chart is reflected under “ series. ”
blue-ribbon or deselect the categories in order to show or hide them from the graph. following, chatter “ apply ” shown at the bottom-left side of the “ values ” check. The filters will be applied to the proto-indo european chart .
Pie Chart Example 1-13

3-D Pie Chart

A three-d ( three-dimensional ) proto-indo european chart is normally used for cosmetic purposes. The features of a three-d pie chart are similar to that of a 2-D proto-indo european graph. however, a three-d pie chart has an extra feature called 3-D rotation, which is not there in a 2-D pie chart .
It is not recommended to use a three-d pie chart for data visual image. The reason is that the numbers represented by the chart may look larger than they actually are. therefore, a three-d proto-indo european graph can be jumble and misleading due to its three-d consequence .

Example #2

Working on the dataset of exemplar # 1, we have changed the head of column B to “ actual sales. ” furthermore, the sales numbers targeted by the organization have been added in column C. We want to perform the take after tasks :

  • Show the outcome when a 3-D pie chart is created by considering the entire dataset. In total, there should be two 3-D pie charts. They should reflect the numbers of both columns (columns B and C) one by one.
  • Interpret the 3-D pie excel charts thus created.

The steps to perform the given tasks are listed as follows :
Step 1: Select the entire dataset ( A1 : C8 ) including column B and C. From the Insert pill, click the proto-indo european graph icon ( in the “ charts ” group ) and choose a three-d pie chart .
The selections are shown in the follow trope. Notice that the column headings have besides been selected before inserting the excel pie chart. This is because we want the name of the column to be displayed as the claim of the chart .

Step 2: A three-d proto-indo european chart has been created, as shown in the keep up visualize. The datum labels have been added to the proto-indo european chart the same way they were added in tax “ barn ” of exercise # 1 .
Notice that though we selected the entire dataset ( in the preceding footstep ), the pie graph displays lone the numbers of column B. The reason is that a pie graph can show only a unmarried series at a time. indeed, by default, Excel is displaying the first ( column B ) of the two series ( column B and C ) .
Pie Chart Example 2-1
Step 3: Filter the series of the pie chart to show the numbers of column C. For filtering, perform the list actions :

  1. Click the pie chart. Three icons appear on the top-right side of the chart.
  2. Click the “chart filters” button (or the filter icon), which is the third of the three icons.
  3. In the “values” tab, the “series” and “categories” are displayed. Select the series “target sales.”
  4. Click “apply.”

The selection of the series “ target sales ” is shown in the watch image .
Example 2-2
Step 4: A three-d pie chart reflecting the numbers of column C has been created. This is shown in the follow double. The datum labels have been added by right-clicking the chart and choosing “ lend data labels. ”
Pie Chart Example 2-3
Interpretation of the two 3-D pie charts: The numbers of column B are reflected in the “ actual sales ” chart ( in footstep 2 ), while those of column C are reflected in the “ aim sales ” chart ( in step 4 ). There are two charts because a proto-indo european chart can display a single data series at one time.

To facilitate comparison, one must place the two pie charts in excel next to each other. On a comparison between the two charts, one can observe that the actual sales of two flavors ( pineapple and orange ) have exceeded the prey sales .
For the grapes relish, the actual and target sales are the same. however, for all the remaining flavors, the target sales bulk is more than the actual sales book. consequently, the organization must focus on pushing the actual numbers closer to the target numbers. thus, a revision of the market plan may be required .

Pie of Pie Chart

A Pie of Pie graph displays an extra proto-indo european along with the chief proto-indo european. This extra proto-indo european ( or secondary proto-indo european ) shows the dissolution of one slice of the main proto-indo european. By default, Excel displays the death three data points of a series on the junior-grade proto-indo european. To avoid this, either of the follow actions can be carried out :

  • Sort the data series in a descending order. By sorting, the smallest three data points of the series are moved to the secondary pie.
  • Choose the data points that will be moved to the secondary pie. For making this choice, the “format data series” panel is used.

A Pie of Pie graph enhances the readability of the chief proto-indo european by moving the smaller slices to the secondary pie. As a result, the exploiter can focus on the slices of both pies, thereby making the graph easy to interpret and analyze. furthermore, with the division of slices ( of the independent proto-indo european ), a Pie of Pie chart can handle more data points than a unconstipated proto-indo european graph .
Note: To know how to use the “ format data series ” control panel in the second bullet point, refer to the surveil exercise .

Example #3

Working on the dataset of case # 1, we have changed the head of column B to “ Jan. ” So, consider that the figures of this column pertain to the calendar month of January of a certain class. Perform the follow tasks :

  1. Make a Pie of Pie chart where the secondary pie displays the last three numbers (or data points) of the dataset. Further, interpret the Pie of Pie chart thus created.
  2. Show how the “format data series” panel is used to decide which data points to be displayed on the secondary pie.

The tasks and the steps to be performed are listed as follows :
Task a: Make a Pie of Pie chart and interpret it
Step 1: Select the entire dataset ( A1 : B8 ). From the Insert yellow journalism, click the proto-indo european icon appearing in the “ charts ” group. Choose the Pie of Pie chart from 2-D proto-indo european charts .
The selections are shown in the pursue picture .

Step 2: The Pie of Pie chart is created, as shown in the pursue picture. Notice that by default, Excel has moved the concluding three data points ( 350, 200, and 400 ) of the series to the secondary pie .
Pie Chart Example 4-1
Interpretation of the Pie of Pie chart: There are 7 numbers in column B of the given dataset. The main proto-indo european shows five slices which consist of the first four data points ( 500, 650, 450, and 580 ) and the sum of the final three data points ( 350+200+400=950 ) .
further, the piece showing the number 950 is the largest region of the independent proto-indo european. This part is joined to the secondary coil proto-indo european with two grey lines. Notice that the end three data points moved to the secondary pie are smaller than the early datum points. With this division of datum points, one can easily focus on both pies at a given time .
so, the main pie can be studied to improve the demand for the prefer flavors ( apple, mango, pineapple, and strawberry ). In contrast, the secondary proto-indo european can be analyzed to identify the causes of low demand for the unpopular flavors ( orange, papaya, and grapes ) .
Task b: Choose the data points to be displayed on the secondary pie
Step 3: Select the Pie of Pie graph and right-click it. Choose the option “ format data series ” from the context menu. This option is shown in the follow double .
Example 4-2
Step 4: The “ format data serial ” paneling opens, as shown in the follow picture. By default, the “ rip series by ” drop-down number shows “ position. ” The option “ position ” tells Excel the count of data points to be moved to the secondary proto-indo european .
The “ values in second diagram ” box shows 3. This implies that the last three data points will be moved to the secondary pie. This total ( 3 ) can be increased or decreased to add or reduce the number of slices of the secondary proto-indo european .
With the default option selections ( shown in the follow image ), the Pie of Pie chart looks the lapp as that of step 2 of this exercise. however, if we enter 4 in the “ values in second gear plot ” box, the slice representing the quantity 580 ( one-fourth last data point ) will besides move to the secondary coil pie .
Note: The different options of the “ rip series by ” drop-down tilt are explained as follows :

  • “Value” or “percentage value”–These options allow specifying the minimum value or percentage below which the data points will be moved to the secondary pie.
  • “Custom”–This option allows selecting a particular slice of the pies manually. Then, one can specify whether this slice should be displayed on the main or secondary pie.

Example 4-3

Bar of Pie Chart

The Bar of Pie chart displays a stack barricade along with the proto-indo european. The legal profession shows the dissolution of one of the slices of the proto-indo european. furthermore, the bar consists of segments that represent data points and are stacked one over the other .
similar to the Pie of Pie chart, the concluding three data points of a series are shown on the bar by default. To move the smallest three data points to the cake, one can sort the serial in a descend order .
One can besides choose the slices or segments ( or data points ) to be shown on the proto-indo european and bar. The slices to be displayed are chosen with the help of the “ format data series ” acid. This pane works the same means it did for the Pie of Pie chart .
A Bar of Pie chart improves the legibility of the proto-indo european and bar, thereby helping the drug user to focus on all the data points of a series .

Example #4

Working on the dataset of model # 1, we have titled column B as “ sales. ” Create a Bar of Pie graph and interpret it .
The steps to create a Bar of Pie chart are listed as follows :
Step 1: Select the entire dataset ( A1 : B8 ). Click the proto-indo european icon from the “ charts ” group of the Insert tab. From 2-D proto-indo european charts, choose the Bar of Pie chart .
The Bar of Pie chart option is shown within a total darkness box in the take after prototype .
Make a PieChart in Excel Example 5
Step 2: The Bar of Pie chart is inserted, as shown in the stick to visualize. Notice that by default, the final three data points ( 350, 200, and 400 ) have been moved to the bar displayed on the right side of the proto-indo european .
Pie Chart Example 5-1
Interpretation of the Bar of Pie chart: The proto-indo european represents the foremost four data points ( 500, 650, 450, and 580 ) of the series ( of column B ) along with the sum of the last three data points ( 350+200+400=950 ) .
The biggest piece of the pie is the brown one. It represents the count 950. This piece is connected to the measure with the avail of grey lines. Notice that the bigger the total, the larger the segment of the prevention. In other words, the larger the segment of the banish or the bigger the slice of the pie, the higher the quantity sold of that spirit .
consequently, the proto-indo european shows the highly choose flavors while the bar shows the less prefer ones. The green section ( papaya ) of the bar is the least prefer as its sphere is the smallest. so, the organization needs to boost sales of the flavors that are not a lot preferred by its customers .

Doughnut Chart

A ring chart Doughnut Chart in Excel A doughnut chart is a type of excel graph whose visual image is alike to pie chart. The categories in this graph are parts that, when combined, represent the solid datum in the chart. A ring chart can only be made using data in rows or column. read more is a discrepancy of the proto-indo european chart of Excel. however, the former is different from the latter in the feel that it can contain more than one datum series. furthermore, a doughnut chart consists of rings alternatively of slices. Further, each ring consists of bow. The inmost ring of the graph represents the foremost data series .
A ring chart is excavate on the inwardly. It is difficult to read and interpret a doughnut chart compared to a even excel proto-indo european chart. From excel 2016, sunburst charts have been introduced, which are more prefer than ring charts .

Example #5

Working on the dataset of case # 1, we have labeled column B as “ Jan. ” This column shows the sales of January. We have besides added the sales of February and March to columns C and D respectively .
In full, there are three series ( Jan, Feb, and Mar ) in the dataset. Perform the keep up tasks :

  • Create a doughnut chart by considering the entire dataset.
  • Title the chart as “Doughnut Pie Chart.”
  • Show the doughnut chart with an enlarged hole.
  • Interpret the chart thus created.

The steps to perform the given tasks are listed as follows :
Step 1: Select the entire dataset ( A1 : D8 ). Click the pie icon from the Insert yellow journalism of Excel. Choose “ ring ” under the doughnut charts .
The selection is shown in the stick to trope .
Note: In Excel 2007, click the “ other charts ” drop-down ( in the “ charts ” group ) from the Insert tab key. following, choose “ ring ” under the ring charts .

Step 2: A ring chart is inserted in Excel, as shown in the take after persona. The “ graph championship ” text box may or may not appear ( by default ) on top of the chart. If the “ chart title ” text box does not appear, perform the follow actions :

  1. Click anywhere on the doughnut chart. The “chart tools” menu of the Excel ribbon becomes visible. It consists of the Design and Format tabs.
  2. Click “add chart element” from the Design tab.
  3. From “chart title,” select either “above chart” or “centered overlay.” A default text box consisting of “chart title” appears.
  4. Type the desired title within the text box.
  5. Click outside the text box to fix the new title to the chart.

If the “ graph deed ” textbook corner does appear, type “ Doughnut Pie Chart ” within it. adjacent, postdate action “ vitamin e ” listed above .
To enlarge the hole of the doughnut chart, perform the follow actions :

  1. Right-click any data series and choose “format data series” from the context menu. The “format data series” pane opens.
  2. In the “series options” tab, there is a slider under “doughnut hole size.” Move this slider to the right to increase the size of the hole. Alternatively, enter a percentage between 10 and 90 in the box. We have entered 75%.

The chart championship and the blown-up trap are shown in the follow image .
Note: In Excel 2007, the “ graph tools ” menu shows the Design, Layout, and Format pill. To add a style to the chart, click the “ graph title ” drop-down ( in “ labels ” group ) from the Layout yellow journalism. next, follow steps “ c, ” “ five hundred, ” and “ e ” listed under the beginning set of actions .

Interpretation of the Doughnut chart: The inmost ring of the chart represents the series “ Jan. ” The middle and the outer rings represent the serial “ Feb ” and “ Mar ” respectively .
Each datum point is represented by an arch in position of a slice. thus, one can say that the bigger the total ( or data point ), the larger the bow representing it. In each resound, there are seven arcs for the seven flavors .
Notice that the spirit papaya has a minor arch ( in greens ) in all the three rings. however, just by looking at the graph, one can not ascertain the numbers represented by the different discharge. Further, had we added data labels to all the three rings, the chart would have become clutter. For these reasons, a regular pie chart is preferred over a doughnut chart .

Frequently Asked Questions

1. Define a pie chart and suggest how to make it in Excel. A pie chart shows the datum points of a single datum series. It is a circular chart consisting of slices. One slice represents one datum period. The entire proto-indo european represents the total of the individual datum points. Zeroes and negative values can not be depicted on a pie chart.

To create a pie chart in Excel, follow the listed steps :

a. Arrange the data series in a single row or single column of Excel.
b. Select the entire dataset including the course and column headings american samoa well as the data series.
c. Click the proto-indo european icon from the “ charts ” group of the Insert yellow journalism.
d. Select the compulsory pie chart like a 2-D pie chart, three-d pie chart, Pie of Pie chart, and so on.

The pie chart selected in footprint “ d ” is inserted in Excel.

Note: For more details on the different types of proto-indo european charts, refer to the definitions and examples given in this article. 2. How to make a pie chart showing percentages in Excel? To create a pie graph showing percentages, follow either of the listed methods :

Method 1– Enter the numbers ( or data points ) as percentages in the data series. These percentages will appear as data labels on the pie graph. For adding such data labels, right-click the proto-indo european chart and choose “ add data labels ” from the context menu.
Method 2– Enter numbers as is in the series and let Excel convert them to percentages. once converted, the numbers and percentages will appear as data labels on the proto-indo european graph. The steps to display such data labels are listed as follows :
a. Right-click any slice of the pie chart and choose “ format data labels ” from the context menu. The “ format data labels ” paneling opens.
b. From the “ pronounce options ” yellow journalism, select “ measure ” and “ percentage ” under “ label contains. ”
c. Close the “ format data labels ” pane.

Note: In both methods, the summarize of all the data points ( or the sum value ) need not necessarily be 100 %. If this total is not 100 %, the outcomes are stated as follows :

• In method acting 1, each slice of the proto-indo european represents a share of the total measure. The sum of all slices ( or data points ) of the pie is any prize other than 100 %.
• In method 2, Excel mechanically makes the sum of all slices of the proto-indo european 100 %. so, the percentage represented by each slice is calculated from the full of 100 %. 3. How to create a pie chart using multiple columns of Excel? Suggest how to resize a pie chart in Excel. It is not possible to create a pie chart using multiple columns or multiple data series. The reason is that a regular pie chart displays the data points ( or categories ) of a single data series alone. so, entirely a individual rowing or a unmarried column can be used as the source dataset of a pie graph.

To display the data points of multiple data series, the ring chart can be used as a version of the regular pie chart.

The steps to resize an excel proto-indo european chart are listed as follows :

a. Click anywhere on the proto-indo european chart. The “ chart tools ” menu appears on the Excel ribbon.
b. Click the “ format ” pill from the “ chart tools ” menu.
c. Type the necessitate size in the “ height ” and “ width ” boxes displayed in the “ size ” group.
d. Press the “ Enter ” key.

Note: Alternatively, increase or decrease the size of the proto-indo european chart by using the arrows of the “ altitude ” and “ width ” boxes.

Recommended Articles

This has been a guide to making Pie graph in Excel. here we discuss how to make the top five types of pie charts, namely, 2-D, three-d, Pie of Pie, Bar of Pie, and Doughnut chart. You may learn more about Excel from the following articles–

reference : https://thaitrungkien.com
Category : Tutorial

Related Posts

Trả lời

Email của bạn sẽ không được hiển thị công khai.