How to make a percentage chart in Excel
To create a percentage chart in Excel, you can use various chart types such as pie charts, column charts, or bar charts. The purpose of a percentage chart is to visually represent the relative proportions or distribution of different categories or data points in a dataset. The chart displays each category as a portion of the whole, represented by percentages.
In this tutorial, we will learn to make a percentage chart in Excel. We have a dataset that includes activities of the day along with the corresponding time spent on each activity. Now, we want to create a percentage graph that illustrates the proportion of time spent on each activity. To achieve this, we can use two methods.
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Dataset-24.png)
Method 1: Make a percentage chart using the Data Callout option
Step 1 – Select the range of cells
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-1-Select-the-range-of-cells-1.png)
- Select the range of cells for which you want to make the chart
Step 2 – Click on the Insert Pie or Doughnut chart
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-2-Click-on-the-Insert-Pie-or-Doughnut-chart.png)
- After selecting the range of cells, click on the Insert Pie or Doughnut chart and a drop-down menu will appear
Step 3 – Select the Type of chart
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-3-Select-the-Type-of-chart-1.gif)
- Click on the chart type you want to insert from the drop-down menu
- Here we selected the 2D pie chart, you may choose any other type of graph and the graph will appear on the sheet
Step 4 – Click on the chart area
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-4-Click-on-the-chart-area.png)
- After the chart appear on the sheet, click on any site of the chart
Step 5 – Click on the Chart Element option
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-5-Click-on-the-Chart-Element-option.png)
- After selecting the chart, click on the Chart Element option and a drop-down menu will appear
Step 6 – Click on the Data label option
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-6-Click-on-the-Data-label-option.png)
- Click on the arrow next to the Data Label option and a right-side menu will appear
Step 7 – Click on the Data Callout option
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-1_-Step-7-Click-on-the-Data-Callout-option.gif)
- Click on the Data Callout option from the right-side menu to get the required result
Method 2: Make a percentage chart using the Format Data Label option
Step 1 – Select the range of cells
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-1-Select-the-range-of-cells-1.png)
- Select the range of cells for which you want to make the chart
Step 2 – Click on the Insert Pie or Doughnut chart
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-2-Click-on-the-Insert-Pie-or-Doughnut-chart.png)
- After selecting the range of cells, click on the Insert Pie or Doughnut chart, and a drop-down menu will appear.
Step 3 – Select the Type of chart
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-3-Select-the-Type-of-chart-1.gif)
- Click on the chart type you want to insert from the drop-down menu
- Here we selected the 2D pie chart, you may choose any other type of graph and the graph will appear on the sheet
Step 4 – Click on the chart area
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-4-Click-on-the-chart-area.png)
- After the chart appear on the sheet, click on any site of the chart
Step 5 – Open the Context menu
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-5-Open-the-Context-menu.png)
- After selecting the chart areas, right-click anywhere on the chart and a context menu will appear
Step 6 – Click on the Format Data Label option
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-6-Click-on-the-Format-Data-Label-option.gif)
- From the context menu, click on the Format Data Label option, and a dialog box will appear on the right side of the sheet
Step 7 – Click on the percentage option
![](https://spreadcheaters.com/wp-content/uploads/Copy-of-Method-2_-Step-7-Click-on-the-percentage-option.gif)
- Click on the checkbox of the Percentage option
- And untick the Number option to get the required result