Back to Excel Charts Menu
What are Data Labels and How to Set Them
Sometimes it is hard to know the exact values depicted in the chart. Let’s have a look for example at the following chart:
How much did Danny scored in English? How much did Lisa score in Math?
In order to know the exact values of the chart’s columns, you can add data labels in the form of small numbers which will appear on the columns:
1. Select the chart by clicking it.
2. Choose the “Layout” tab.
3. Click the “Data Labels” button.
4. Choose one of the label’s locations from the menu.
(In the current example I chose "Inside End")
That's it! Now the chart's columns have numbers inside of them indicating their values.
Here is how the chart looks like after we inserted the data labels: