Display Chart Labels in Microsoft Excel

This Small Shot shows you how to display data labels on a chart in Microsoft Excel 2007 or higher.

The Steps

  1. Click on the chart
  2. Select Layout from Chart Tools
  3. Click Data Labels from the Labels group
  4. Select a label display – None, Center, Inside End, Outside End, or Best Fit

There you have it! Your chart should look similar to the one below.  For our chart, we selected Inside End as our label display.

The Shortcut

  1. Click on the chart “series”
  2. Press keyboard shortcut F10 (function key 10), to display shortcut menu
  3. From the shortcut menu, select Add Data Labels

There you have it, again!

Return to Home Page