This Small Shot shows you how to format chart data labels in Microsoft Excel 2007 or higher.
- Select your data label(s)
- Click Format from Chart Tools
- 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.
- Select you data labels
- Press keyboard shortcut Ctrl-1 to display the Format Data Labels dialog box