Format Chart Data Labels in Microsoft Excel

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

The Steps

  1. Select your data label(s)
  2. Click Format from Chart Tools
  3. Select Format Selection from Current Selection group. A dialog box appears (see below), allowing you different formatting options.

Use the options in the Format Data Labels dialog box to format your data labels. Below is how we formatted our data labels.

The Shortcut

  1. Select you data labels
  2. Press keyboard shortcut Ctrl-1 to display the Format Data Labels dialog box
Return to Home Page