How to Add Data Labels in Excel: 2 Handy Methods

Method 1 – Inserting Chart Elements Command to Add Data Labels in Excel

Step 1:

  • Select your entire data set to create a chart or graph.
  • The cell range is B4:D10 in our example.

Handy Ways to Add Data Labels in Excel

Step 2:

  • Create a 2D clustered column chart.
  • Go to the Insert tab of the ribbon.
  • Choose the Insert Column or Bar Chart command from the Chart group.
  • Select the Clustered Column command.

Handy Ways to Add Data Labels in Excel

Step 3:

  • After selecting, you will be able to create the chart.
  • Name the chart “Height vs. Weight” for example.
  • You will notice that there are no data labels in the chart.

Handy Ways to Add Data Labels in Excel

Step 4:

  • Add the data labels to our chart.
  • Click on the chart and you will see three icons right beside the chart.
  • Of the three icons, the first one is the Chart Elements command.
  • Click on that command, and you will see more commands regarding the chart.
  • Mark the Data Labels command, which was previously unmarked.

Handy Ways to Add Data Labels in Excel

  • After marking the command, you will see all the data labels above the columns accordingly.

Handy Ways to Add Data Labels in Excel

Step 5:

  • Add the data labels in another way, then select any column of the same variable and then right-click on it.
  • Rght-click on the column that represents Height.
  • Select the Add Data Labels command.

Handy Ways to Add Data Labels in Excel

  • See the data labels for the columns that represent Height.

Handy Ways to Add Data Labels in Excel

Step 6:

  • Repeat the same process from Step 5 by selecting any column that represents the person’s weight.
  • See the data labels after repeating the process.

Handy Ways to Add Data Labels in Excel


Method 2 – Applying VBA to Add Data Labels in Excel

Step 1:

  • Use the following data set for our procedure.

Handy Ways to Add Data Labels in Excel

Step 2:

  • Create a 2D clustered column chart by using the above data set.
  • Repeat Step 1 to Step 2 from the previous method to get our chart.
  • Name the chart “Height vs. Weight.”

Handy Ways to Add Data Labels in Excel

Step 3:

  • Choose the Visual Basic command from the Code in the Developer tab of the ribbon.

Sample Data Set

Step 4:

  • A new tab will open after choosing this command.
  • From the new tab, select Module from the Insert tab.

Sample Data Set

Step 5:

  • Into the Module paste the following VBA Code, which will add data labels after running the program.
Sub Add_Data_Labels()
Dim ch As ChartObject
Set ch = ActiveSheet.ChartObjects("Chart 1")
ch.Chart.SetElement (msoElementDataLabelOutSideEnd)
End Sub

VBA Code for adding Data Label

  • Save the program in the module and press the play button to run the code.

Running VBA Code

Step 6:

  • Add data labels to the chart with the help of VBA.

Sample Data Set

How Does the Code Work?

  • Set ch = ActiveSheet.ChartObjects("Chart 1")

This line of code assigns the chart to the chart type variable ch on which we want to add the data label (Chart 1 in my case).

  • ch.Chart.SetElement (msoElementDataLabelOutSideEnd)

This line of code adds data labels with Outside End orientation to the chart. We can use, such as Inside End, Inside Base, Data Callout, etc. For using any of those, we need to use their corresponding property in SetElemet.


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


Related Articles


<< Go Back To Data Labels in ExcelExcel Chart Elements | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo