# Percentage Data Label in Your Excel Chart

Last Updated on 12/06/2023
Reading time: 2 minutes

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

## 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

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 label 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

• Values
• 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?

# Percentage Data Label in Your Excel Chart

Reading time: 2 minutes
Last Updated on 12/06/2023

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

## 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

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 label 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

• Values
• 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?