create pie chart excel showing percentages

To add percentages as labels on the doughnut chart, with the chart selected, click on the Chart Elements button. This inserts a doughnut 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 Doughnut to insert a doughnut chart. Enter and select the data that you will use to create the doughnut chart.Ģ. Steps for creating a doughnut chart are almost the same as for a pie chart:ġ. Finally, remove the chart title by unticking the Chart Title option in the Chart Elements menu.Īnother chart that can be used to show percentages is a doughnut chart. However, there are other options as well such as Center, Inside End or Outside End.ħ. By default, the Best Fit is chosen which means Excel chooses the best position for percentage labels on the pie chart. In the Label Position section, choose a position to place the labels. If you want to display both percentage and value labels on the chart, tick both options.Ħ. In the Format Data Labels task pane, untick Value and tick the Percentage option to show only percentages. This opens the Format Data Labels task pane.ĥ. In the opened submenu, click on More options. In the Chart Elements menu, hover your cursor over the Data Labels option and click on the arrow next to it.Ĥ. To add percentages as labels on the pie chart, with the chart selected, click on the Chart Elements button. 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. Enter and select the data that you will use to create the pie chart.Ģ. To create a pie chart, take the following steps:ġ. The most common chart type used to show percentages is a pie chart. If you prefer written instructions, then continue reading. Watch the video below to see how to show percentages on a pie, a doughnut and a bar chart in Excel. In other Excel versions, there may be some slight differences in the described steps. In Excel, you can use three different charts, namely a pie chart, a doughnut chart and a bar chart to show percentages of a whole. Percentage is one of the most common ways of expressing a proportion.

Create pie chart excel showing percentages