Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table. You can create graphs, pie charts, trends of a particular business or scientific model and so on. The numbers of features are almost endless.

You can also show a data table for a line chart, area chart, column chart, or bar chart. A data table displays the values that are presented in the chart in a grid at the bottom of the chart.

While you are working with a chart on MS Excel, you may need to show or hide the values of the data, depending on the requirement of the table. The data values at the discrete points are called data labels. You can show or hide the data labels. You can also change the position of the data labels. These are extremely easy. In this tutorial, I shall show you, how to do it.

Steps To Show Or Hide Data Labels On MS Excel

If you want to SHOW Legend

data label MS Excel
  1. Select the chart on your MS Excel worksheet, A plus sign will appear at the top right corner of the table.
  2. Now, you need to point to Data Labels and select the arrow next to it.
  3. Choose the location of placement of Data Labels, like center, inside end, outside end, base end, callouts, etc.
  4. You are done!
data label MS Excel

If you want to HIDE Data Label

  1. Simply uncheck the option.

That’s all!


Happiness is that best therapy. Use it to heal yourself and then others!


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.