italyllka.blogg.se

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.