In an Excel chart, you can display your data labels as a percentage of the total without doing any calculations 😀👍
Step 1: Add the data labels to the chart
The first thing you need to do is to add data labels to your chart.
- Select your chart
- Click on the + at the top right
- Select the Data label check box
At this time, the labels match the values in your table.
Step 2: Open the label pane
Next, open the label pane. You can do this in 2 ways
- Or, from the chart, by clicking on the arrow to the right of the data labels menu and finally, Other options
- Or by double-clicking on the labels in the chart.
In both cases, you open the label options pane on the right side of your worksheet.
Step 3: Apply the percentage to the data labels of your Excel chart
Now, In the option's label (the icon that looks like a chart), you see the Percentage option.
Click on this option to instantly convert your data label into the percentage of the total in your Excel chart😀👏👍
Step 4: Display multiple values in the labels
This step is unnecessary but will show you that you can put several pieces of information inside a single data label.
For example, here, we have chosen to display
- The percentage
- As a separator, a line break
- And finally, the positioning is on the inner edge
The result is
With the steps outlined in this tutorial, you should be able to easily and accurately add percentage labels to your charts and graphs.
We hope this tutorial has been helpful and that you can apply what you have learned to your future data visualization projects.
Related articles about the Percentage
How to do percentages in a pivot table without a formula?
What is the formula to calculate the percentage of increase or decrease?