![how to make a pie chart in excel equal 100 percent how to make a pie chart in excel equal 100 percent](https://templatelab.com/wp-content/uploads/2020/04/pie-chart-template-01.jpg)
Black cropping handles will appear around the image. To extract the legend out of the pasted image, click on the Format tab under Picture Tools and then click the Crop button in the Size group.Copy the chart and paste it as a picture by clicking the Paste drop down menu and selecting Picture among the Paste Options.Extract the legend out of the chart in order to use it later as the legend of the final chart. In the opened submenu, choose Right to place the legend at the right of the chart.ħ. To do that, hover your cursor over the Legend option in the Chart Elements menu and click on the arrow next to it. Change the legend position to the right.Remove the chart title by clicking on the Chart Elements button and unticking the Chart Title option in the Chart Elements menu.Make the chart area transparent by clicking on the chart and on Format tab under Chart Tools, changing the Shape fill to No Fill and the Shape Outline to No Outline for the chart area.Remove the white outline from around the slices by clicking on the pie and on the Format tab under Chart Tools, choosing No Outline in the Shape Outline drop down menu.Do the following formatting changes in the chart: This inserts a pie chart into the worksheet.Ħ. On the Insert tab of the ribbon, in the Charts group, click on the Insert Pie or Doughnut Chart button and in the opened menu, click on the first option among the 2-D Pie Charts. Select the data that you will use to create the pie chart. To format the cells as numbers with two decimal places, click the Number Format drop down menu in the Number group of the Home tab and select Number.ĥ. To find the widths of charts, divide the areas by the heights by writing the formula =C2/D2 in the adjacent cell and copying it down to the other cells below.Ĥ. Considering the largest chart area size in our example is 25.27, I set the heights of charts to 5 and write it in the next column. Set the heights and widths of charts to be created. These percentage values will be used as the sizes of the chart areas of pie charts to be created.ģ. To calculate the percentage proportion of each country, write the formula =B2/SUM($B$2:$B$11)*100 in the cell next to the count of the first country and copy it down to the other cells below. Calculate the percentage proportion of each country next to its count of gold medals. For the purpose of this tutorial, I am using the data of top 10 gold medal winning countries of the Rio 2016 Olympics.Ģ. Enter the data that you will use to create the pie chart. The basic idea in creating this chart is to make a separate pie chart for each category in which only the slice representing that category is visible, set the area of each chart equal to the percentage value of its visible category and then combine all charts together to create one single pie chart. If you prefer written instructions, then continue reading.
![how to make a pie chart in excel equal 100 percent how to make a pie chart in excel equal 100 percent](https://i.ytimg.com/vi/y4cQclQv_X0/maxresdefault.jpg)
![how to make a pie chart in excel equal 100 percent how to make a pie chart in excel equal 100 percent](https://venturebeat.com/wp-content/uploads/2019/02/Ian-Young.jpg)
HOW TO MAKE A PIE CHART IN EXCEL EQUAL 100 PERCENT HOW TO
Watch the video below to see how to create a pie chart in Excel in which each slice has a different radius based on the percentage it represents. In other Excel versions, there may be some slight differences in the described steps. For all these reasons, I have decided to create this pie chart in Excel and share it with you. Also, it can be a visually nice addition to any dashboard, report or presentation. The advantage of such a pie chart is that it further emphasizes the relative importance of a particular category to the total and is useful when you want to draw attention to categories with large percentages. In infographics and other visuals, I have many times come across a pie chart in which each slice has a different radius based on the percentage it represents: the slices representing categories with large percentages have larger radii (the plural of radius is radii), while the slices representing categories with small percentages have shorter radii.