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.
Method 1: Make a percentage chart using the Data Callout option
Step 1 – Select the range of cells
- Select the range of cells for which you want to make the chart
Step 2 – Click on the Insert Pie or Doughnut chart
- 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
- 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
- After the chart appear on the sheet, click on any site of the chart
Step 5 – Click on the Chart Element option
- 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
- 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
- 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
- Select the range of cells for which you want to make the chart
Step 2 – Click on the Insert Pie or Doughnut chart
- 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
- 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
- After the chart appear on the sheet, click on any site of the chart
Step 5 – Open the Context menu
- 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
- 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
- Click on the checkbox of the Percentage option
- And untick the Number option to get the required result