What are Pie Charts in Excel?
A proto-indo european chart is a circular representation that reflects the numbers of a single rowing or single column of Excel. The individual numbers are called data points ( or categories ) and a list ( row or column ) of numbers is called a datum series. Every proto-indo european chart consists of slices ( or parts ), which when added make a complete proto-indo european ( or circle ) .
For model, the be picture shows some proto-indo european charts of Excel. On the top, the three-d pie chart is to the leave and the Pie of Pie graph is to the mighty. At the bottom, the Bar of Pie graph is to the left and the Doughnut chart is to the justly .
You are barren to use this double 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 determination of making a pie chart in Excel is to visualize data when there are a few datum points. furthermore, all the datum points should belong to a specific time menstruation. A proto-indo european graph is not suitable when there are many data points or the datum points pertain to different time periods.
Reading: Pie Charts in Excel
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 comply proto-indo european charts :
- 2-D pie chart
- 3-D pie chart
- Pie of Pie chart
- Bar of Pie chart
- Doughnut chart
Let us create each Excel pie chart one by one with the help of examples .
2-D Pie Chart
A 2-D ( planar ) proto-indo european chart is frequently used in Excel. It is a standard proto-indo european chart that displays one cut for each data period. The bigger the number ( or data point ) represented by the slit, the larger the sphere under it .
The pursuit image 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 following tasks :
- Make a 2-D pie chart in Excel by taking into account the given dataset. Interpret the pie chart thus created.
- Add data labels and data callouts to the pie chart.
- Separate a few slices from the pie (or circle) and show how to change their color.
- Rotate the slices and increase the gap between them.
- Change the chart style and show how to apply filters to the pie chart in excel.
note that the numbers pertain to a specific fourth dimension menstruation .
The tasks and the corresponding 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 ). following, click the proto-indo european chart icon from the “ charts ” group of the Insert pill. Select a 2-D proto-indo european chart .
The selections are shown in the keep up prototype .
Step 2: A 2-D pie chart is inserted in Excel. This is shown in the postdate trope .
Notice that the caption ( on acme ) and the caption ( at the bottom ) are automatically added to the chart. The caption of the chart is the lapp as the heading of column B. The caption reflects all the flavors of column A .
Interpretation of the 2-D pie chart: Each slice of the chart displays the total of beverages sold in a particular time menstruation. One slice represents one flavor of the beverage. When all the slices are added, a complete proto-indo european is obtained. therefore, the entire proto-indo european represents the sum 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 maximal and that of papaya ( 200 ) are the least. The second highest sales are of the strawberry relish ( 580 ) .
Hence, one can interpret that the mango season of the beverage has the highest demand. In contrast, the papaya spirit is not much preferred by the customers of the administration .
Task b: Add data labels and data callouts
Step 3: Right-click the pie chart and expand the “ add data labels ” option. following, choose “ add data labels ” again, as shown in the adopt image .
Step 4: The data labels are added to the chart, as shown in the pursuit picture. With these labels, the sales quantity of each flavor is displayed on the respective slice. frankincense, data labels make it easy to read and interpret an excel pie chart .
Note: Data labels are directly linked to the datum points of the source dataset. consequently, the datum labels automatically update with a change in the data points .
Step 5: Right-click the proto-indo european chart again. Click the arrow of “ add data labels ” and choose “ add data callouts. ” The data callouts have been added in the adopt image .
Notice that each slice shows the appoint of the relish along with its share in the stallion pie. Since the share is in percentage, a glance at the proto-indo european chart can suggest the highly favored and the less choose flavors. The entire of the pie is 100 % .
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 pie with the assistant of the shiner arrow. In the follow image, the slices having the utmost ( orange colored ) and the minimum sales ( fleeceable colored ) have been separated from the pie .
Note: To join the slices to the proto-indo european again, drag them binding to their stead. alternatively, press the undo shortcut “ Ctrl+Z. ”
Step 7: Double-click the piece whose color is to be changed. following, right-click it and select the option “ format data steer ” from the context menu. This choice is shown in the play along double .
Step 8: The “ format data point ” paneling opens, as shown in the follow image. In the “ meet ” check, the “ automatic pistol ” and “ change colors by slice ” options are selected by default .
If the “ color ” choice is visible ( shown within the loss box ), select the craved tinge from it. If the “ semblance ” option is not visible, choose “ firm meet ” and then choose the coveted semblance. Next, close the “ format data point ” pane .
The selected color will be applied to the slit that was double-clicked in the precede step .
Note: One can highlight the important slices and assign dull colors to the remaining ones. then, the small and non-relevant slices can be filled with lighter colors. This helps focus on specific datum points .
Task d: Rotate the slices and increase the gap between them
Step 9: Select the pie chart and right-click it. Choose “ format data serial ” from the context menu. This option is shown in the follow prototype .
Step 10: The “ format data series ” pane opens, as shown in the be effigy. In the “ series options ” tab, perform the follow actions :
- In “angle of first slice,” enter 96◦ (96 degrees).
- In “pie explosion,” enter 18% (18 percent).
next, close the “ format data series ” acid .
Step 11: The slices of the pie have been rotated. furthermore, the gap between them has been increased. This is shown in the follow trope .
Notice that the integral proto-indo european has been rotated. so, 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 .
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 play along 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 keep up image .
When the cursor is hovered over the unlike chart styles, a preview is shown in Excel. so, the preview helps see the room the proto-indo european chart would look if the respective stylus is selected .
Step 13: Click the “ chart filters ” button ( or the filter icon ) displayed on the top-right english of the chart .
In the “ values ” check ( shown in the pursue persona ), all the flavors of the beverage are shown under “ categories. ” The individual column ( column B ) used to create the excel proto-indo european chart is reflected under “ series. ”
blue-ribbon or deselect the categories in order to show or hide them from the graph. future, click “ apply ” shown at the bottom-left side of the “ values ” check. The filters will be applied to the proto-indo european chart .
3-D Pie Chart
A three-d ( cubic ) proto-indo european chart is normally used for cosmetic purposes. The features of a three-d proto-indo european chart are like to that of a 2-D pie chart. however, a three-d proto-indo european 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 proto-indo european chart for data visual image. The rationality is that the numbers represented by the chart may look larger than they actually are. so, a three-d pie chart can be confuse and misleading due to its three-d effect .
Working on the dataset of model # 1, we have changed the head of column B to “ actual sales. ” furthermore, the sales numbers targeted by the administration have been added in column C. We want to perform the play along 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 check, click the proto-indo european chart icon ( in the “ charts ” group ) and choose a three-d proto-indo european graph .
The selections are shown in the keep up image. Notice that the column headings have besides been selected before inserting the excel proto-indo european graph. This is because we want the name of the column to be displayed as the championship of the chart .
Step 2: A three-d proto-indo european chart has been created, as shown in the pursue effigy. The datum labels have been added to the pie chart the same way they were added in undertaking “ barn ” of exemplar # 1 .
Notice that though we selected the entire dataset ( in the past footprint ), the pie chart displays only the numbers of column B. The reason is that a proto-indo european chart can show entirely a single series at a fourth dimension. therefore, by nonpayment, Excel is displaying the first gear ( column B ) of the two serial ( column B and C ) .
Step 3: Filter the series of the proto-indo european chart to show the numbers of column C. For filtering, perform the list actions :
- Click the pie chart. Three icons appear on the top-right side of the chart.
- Click the “chart filters” button (or the filter icon), which is the third of the three icons.
- In the “values” tab, the “series” and “categories” are displayed. Select the series “target sales.”
- Click “apply.”
The choice of the series “ target sales ” is shown in the following image .
Step 4: A three-d proto-indo european chart reflecting the numbers of column C has been created. This is shown in the following image. The data labels have been added by right-clicking the chart and choosing “ total data labels. ”
Interpretation of the two 3-D pie charts: The numbers of column B are reflected in the “ actual sales ” graph ( in pace 2 ), while those of column C are reflected in the “ target sales ” chart ( in measure 4 ). There are two charts because a pie chart can display a single data series at one time.
Read more : How to Lower Your Electric Bill – NerdWallet
To facilitate comparison, one must place the two pie charts in excel following 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 target sales .
For the grapes season, the actual and target sales are the same. however, for all the remaining flavors, the target sales volume is more than the actual sales book. consequently, the organization must focus on pushing the actual numbers closer to the target numbers. thus, a rewrite of the marketing plan may be required .
Pie of Pie Chart
A Pie of Pie chart displays an extra pie along with the independent pie. This extra pie ( or secondary coil proto-indo european ) shows the separation of one cut of the independent proto-indo european. By default, Excel displays the last three data points of a series on the secondary proto-indo european. To avoid this, either of the watch 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 chart enhances the readability of the main proto-indo european by moving the smaller slices to the secondary proto-indo european. As a consequence, the exploiter can focus on the slices of both pies, thereby making the chart easy to interpret and analyze. furthermore, with the division of slices ( of the chief proto-indo european ), a Pie of Pie chart can handle more data points than a even pie graph .
Note: To know how to use the “ format data series ” panel in the second gear bullet point, refer to the postdate example .
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 refer to the calendar month of January of a certain year. Perform the be tasks :
- 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.
- 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 check, click the proto-indo european picture appearing in the “ charts ” group. Choose the Pie of Pie chart from 2-D proto-indo european charts .
The selections are shown in the following trope .
Step 2: The Pie of Pie graph is created, as shown in the take after trope. Notice that by default, Excel has moved the final three data points ( 350, 200, and 400 ) of the series to the secondary proto-indo european .
Interpretation of the Pie of Pie chart: There are 7 numbers in column B of the given dataset. The main pie shows five slices which consist of the first gear four datum points ( 500, 650, 450, and 580 ) and the total of the last three data points ( 350+200+400=950 ) .
far, the cut showing the number 950 is the largest part of the chief pie. This contribution is joined to the junior-grade pie with two grey lines. Notice that the last 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 fourth dimension .
so, the main pie can be studied to improve the demand for the prefer flavors ( apple, mango, pineapple, and strawberry ). In contrast, the secondary pie can be analyzed to identify the causes of broken 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 chart and right-click it. Choose the option “ format data series ” from the context menu. This choice is shown in the following persona .
Step 4: The “ format data series ” acid opens, as shown in the follow image. By default, the “ split series by ” drop-down list shows “ position. ” The option “ position ” tells Excel the issue of data points to be moved to the secondary pie .
The “ values in second plot ” box shows 3. This implies that the death three datum points will be moved to the secondary coil proto-indo european. This number ( 3 ) can be increased or decreased to add or reduce the numeral of slices of the secondary pie .
With the default selections ( shown in the follow prototype ), the Pie of Pie chart looks the like as that of step 2 of this exercise. however, if we enter 4 in the “ values in second plot ” box, the piece representing the quantity 580 ( fourth death data point ) will besides move to the secondary proto-indo european .
Note: The different options of the “ split series by ” drop-down list 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.
Bar of Pie Chart
The Bar of Pie chart displays a stack bar along with the proto-indo european. The bar shows the separation 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 early .
alike to the Pie of Pie graph, the final three data points of a serial are shown on the prevention by default. To move the smallest three data points to the barricade, one can sort the series in a fall 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 avail of the “ format data series ” acid. This acid works the same way it did for the Pie of Pie chart .
A Bar of Pie chart improves the readability of the proto-indo european and bar, thereby helping the drug user to focus on all the datum points of a series .
Working on the dataset of example # 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 yellow journalism. From 2-D pie charts, choose the Bar of Pie chart .
The Bar of Pie chart choice is shown within a black box in the come picture .
Step 2: The Bar of Pie chart is inserted, as shown in the follow prototype. Notice that by default, the last three data points ( 350, 200, and 400 ) have been moved to the bar displayed on the right side of the pie .
Interpretation of the Bar of Pie chart: The pie represents the first four datum points ( 500, 650, 450, and 580 ) of the series ( of column B ) along with the entire of the last three data points ( 350+200+400=950 ) .
The biggest slit of the proto-indo european is the brown one. It represents the issue 950. This slice is connected to the bar with the help of grey lines. Notice that the bigger the number, the larger the section of the bar. In early words, the larger the section of the legal profession or the bigger the cut of the pie, the higher the quantity sold of that relish .
therefore, the pie shows the highly preferable flavors while the measure shows the less prefer ones. The green segment ( papaya ) of the browning automatic rifle is the least favored as its area is the smallest. so, the arrangement needs to boost sales of the flavors that are not much preferred by its customers .
A ring chart Doughnut Chart in Excel A ring chart is a type of excel chart whose visual image is like to pie chart. The categories in this chart are parts that, when combined, represent the whole data in the chart. A doughnut chart can only be made using data in rows or column. read more is a variant of the proto-indo european chart of Excel. however, the erstwhile is different from the latter in the sense that it can contain more than one datum series. furthermore, a doughnut chart consists of rings rather of slices. Further, each ring consists of discharge. The inmost ring of the chart represents the first data serial .
A ring chart is hole on the at heart. It is difficult to read and interpret a doughnut chart compared to a even excel proto-indo european graph. From excel 2016, sunburst charts have been introduced, which are more prefer than ring charts .
Working on the dataset of model # 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 sum, there are three series ( Jan, Feb, and Mar ) in the dataset. Perform the following 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 stallion dataset ( A1 : D8 ). Click the pie icon from the Insert tab of Excel. Choose “ ring ” under the doughnut charts .
The survival is shown in the watch image .
Note: In Excel 2007, click the “ other charts ” drop-down ( in the “ charts ” group ) from the Insert pill. next, choose “ doughnut ” under the ring charts .
Step 2: A ring chart is inserted in Excel, as shown in the follow visualize. The “ chart title ” text box may or may not appear ( by default ) on acme of the graph. If the “ chart title ” text box does not appear, perform the pursuit actions :
- Click anywhere on the doughnut chart. The “chart tools” menu of the Excel ribbon becomes visible. It consists of the Design and Format tabs.
- Click “add chart element” from the Design tab.
- From “chart title,” select either “above chart” or “centered overlay.” A default text box consisting of “chart title” appears.
- Type the desired title within the text box.
- Click outside the text box to fix the new title to the chart.
If the “ chart deed ” text box does appear, type “ Doughnut Pie Chart ” within it. adjacent, trace action “ einsteinium ” listed above .
To enlarge the trap of the doughnut chart, perform the follow actions :
- Right-click any data series and choose “format data series” from the context menu. The “format data series” pane opens.
- 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 title and the blow up hole are shown in the follow image .
Note: In Excel 2007, the “ chart tools ” menu shows the Design, Layout, and Format tab key. To add a entitle to the chart, click the “ chart championship ” drop-down ( in “ labels ” group ) from the Layout pill. next, follow steps “ c, ” “ five hundred, ” and “ e ” listed under the first sic of actions .
Interpretation of the Doughnut chart: The inmost ring of the chart represents the series “ Jan. ” The middle and the out rings represent the series “ Feb ” and “ Mar ” respectively .
Each datum point is represented by an arc in place of a piece. so, one can say that the bigger the phone number ( or data target ), the larger the discharge representing it. In each ring, there are seven arcs for the seven flavors .
Notice that the flavor papaya has a small arch ( in green ) in all the three rings. however, fair by looking at the chart, one can not ascertain the numbers represented by the different arc. Further, had we added data labels to all the three rings, the chart would have become clutter. For these reasons, a unconstipated proto-indo european chart is preferred over a doughnut chart .
Frequently Asked Questions
1. Define a pie chart and suggest how to make it in Excel. A proto-indo european chart shows the data points of a individual datum series. It is a round chart consisting of slices. One piece represents one datum point. The entire pie represents the entire of the individual datum points. Zeroes and negative values can not be depicted on a pie graph.
To create a pie chart in Excel, follow the listed steps :
a. Arrange the data series in a single row or one column of Excel.
b. Select the entire dataset including the rowing and column headings ampere well as the data series.
c. Click the proto-indo european picture from the “ charts ” group of the Insert yellow journalism.
d. Select the want proto-indo european chart like a 2-D proto-indo european graph, three-d pie chart, Pie of Pie chart, and so on.
The proto-indo european chart selected in step “ d ” is inserted in Excel.
Note: For more details on the different types of pie 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 chart showing percentages, follow either of the listed methods :
• Method 1– Enter the numbers ( or data points ) as percentages in the datum series. These percentages will appear as data labels on the pie graph. For adding such data labels, right-click the pie graph 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 chart. The steps to display such data labels are listed as follows :
a. Right-click any slice of the pie graph and choose “ format data labels ” from the context menu. The “ format data labels ” acid opens.
b. From the “ label options ” tab key, select “ value ” and “ share ” under “ label contains. ”
c. Close the “ format data labels ” acid.
Note: In both methods, the sum of all the datum points ( or the total value ) need not necessarily be 100 %. If this sum is not 100 %, the outcomes are stated as follows :
• In method 1, each slice of the proto-indo european represents a share of the sum respect. The sum of all slices ( or data points ) of the proto-indo european is any rate other than 100 %.
• In method 2, Excel automatically makes the total of all slices of the proto-indo european 100 %. so, the percentage represented by each slice is calculated from the sum 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 potential to create a proto-indo european chart using multiple columns or multiple data serial. The reason is that a regular proto-indo european chart displays the data points ( or categories ) of a single datum series only. so, alone a single row 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 discrepancy of the regular pie chart.
The steps to resize an excel proto-indo european chart are listed as follows :
a. Click anywhere on the pie chart. The “ chart tools ” menu appears on the Excel ribbon.
b. Click the “ format ” check from the “ chart tools ” menu.
c. Type the ask size in the “ acme ” and “ width ” boxes displayed in the “ size ” group.
d. Press the “ Enter ” winder.
Note: Alternatively, increase or decrease the size of the proto-indo european chart by using the arrows of the “ height ” and “ width ” boxes.
This has been a guide to making Pie chart in Excel. here we discuss how to make the exceed 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–
Read more : How to take a screenshot on LG smartphones