Show Data Labels on a Column Chart – Tutorial

Column chart to show data labels.

There are only a few steps to show data labels on a column chart. Data labels provide a value you can use to make comparisons.

For the purpose of this tutorial, we use Excel 2016. However, you can follow along in most previous versions of Excel. 

Steps to Show Data Labels on a Column Chart

Follow the steps below to display labels on a column chart.

Selected column chart.
Selected column chart showing Chart Tools ribbon.
Adding the labels to the column chart.
Adding data labels to the column chart.
  1. Select your column chart.
  2. Under Chart Tools, click Design.
  3. On the far left of the Chart Tools ribbon, click Add Chart Element.
  4. Under Chart Element, click Data Labels.
  5. Under Data Labels, click Outside End or the label option of your choice.

Success!

Column charts showing data labels.
Column charts showing data labels.

You have just added data labels to a column chart.


Additional Information

Related Tutorials

External Links


Tutorials

Techronology Home