Percentage Data Label in Your Excel Chart

Percentage Data Label in Your Excel Chart
Last Updated on 06/06/2024
Reading time: 2 minutes

In an Excel chart, you can display your data label as a percentage of the total without doing any calculations 😀👍

  1. Create a pie chart

    This is the best chart type to display values or percentage

  2. Add labels to your chart

    Add labels in values

  3. Change the options of the labels

    Among the label options, you can replace the values with percentage

Step 1: Add the data label to the chart

The first thing you need to do is to add data labels to your chart.

  1. Select your chart
  2. Click on the + at the top right
  3. Select the Data label check box
Add Data Label into an Excel chart

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
Open More Data Label 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: Change the label contains to percentage in your Excel chart

Now, In the option's label (the icon that looks like a chart), you see the Percentage option.

Percentage options in the Data Label

Click on this option to instantly convert your data label into the percentage of the total in your Excel chart😀👏👍

Percentage in the data labels

Step 4: Display multiple values in the labels

This step is not compulsory, but it will show you that you can include several pieces of information in a single data label. For example, here, we have chosen to display

  • Values
  • The percentage
  • As a separator, a line break
  • And finally, the positioning is on the inner edge
Many information in the same data label

The result is

Data labels with more than one information

With the steps outlined in this tutorial, you should be able to add percentage labels to your charts and graphs easily and accurately. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

Percentage Data Label in Your Excel Chart

Reading time: 2 minutes
Last Updated on 06/06/2024

In an Excel chart, you can display your data label as a percentage of the total without doing any calculations 😀👍

  1. Create a pie chart

    This is the best chart type to display values or percentage

  2. Add labels to your chart

    Add labels in values

  3. Change the options of the labels

    Among the label options, you can replace the values with percentage

Step 1: Add the data label to the chart

The first thing you need to do is to add data labels to your chart.

  1. Select your chart
  2. Click on the + at the top right
  3. Select the Data label check box
Add Data Label into an Excel chart

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
Open More Data Label 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: Change the label contains to percentage in your Excel chart

Now, In the option's label (the icon that looks like a chart), you see the Percentage option.

Percentage options in the Data Label

Click on this option to instantly convert your data label into the percentage of the total in your Excel chart😀👏👍

Percentage in the data labels

Step 4: Display multiple values in the labels

This step is not compulsory, but it will show you that you can include several pieces of information in a single data label. For example, here, we have chosen to display

  • Values
  • The percentage
  • As a separator, a line break
  • And finally, the positioning is on the inner edge
Many information in the same data label

The result is

Data labels with more than one information

With the steps outlined in this tutorial, you should be able to add percentage labels to your charts and graphs easily and accurately. 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

Leave a Reply

Your email address will not be published. Required fields are marked *