Click the titles of each category list to expand and collapse the display of the options in that category.The formatting options for the category appear in collapsible and expandable lists at the bottom of the task pane.Then click the desired category icon to edit.

To choose other formatting categories to show in the task pane, click the desired options to set.

Set the values and positioning of the data labels in the “Label Options” category, which is shown by default.

Using either method then displays the “Format Data Labels” task pane at the right side of the screen.

Then select the “Format Data Labels…” command from the pop-up menu that appears to format data labels in Excel.

Alternatively, right-click the desired set of data labels to format within the actual chart.

Then click the “Format Selection” button that appears below the drop-down menu in the same area.

Then select the data labels to format from the “Current Selection” button group.

One way to do this is to click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon.

To format data labels in Excel, choose the set of data labels to format.

Format Data Labels in Excel: Instructions Then click the “X” in the upper-right corner of the task pane to close it. Set any options you want within the task pane to immediately apply them to the chart. The formatting options for the category then appear in collapsible and expandable lists at the bottom of the task pane.Ĭlick the titles of each category list to expand and collapse the options within that category. Then click the desired category icon to edit. To do this, click the options to set, like the “Label Options” or “Text Options” choice. You can also choose other formatting categories to display within the task pane. In the “Label Options” category, which is shown by default, you set the values and positioning of the data labels. This task pane is where you format data labels in Excel. Using either method then displays the “Format Data Labels” task pane at the right side of the screen.įormat Data Labels in Excel- Instructions: A picture of the “Format Data Labels” task pane in Excel. Then select the “Format Data Labels…” command from the pop-up menu that appears to format data labels in Excel. Then click the “Format Selection” button that appears below the drop-down menu in the same area.Īlternatively, you can right-click the desired set of data labels to format within the chart. Then select the data labels to format from the “Chart Elements” drop-down in the “Current Selection” button group.

To do this, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. To format data labels in Excel, choose the set of data labels to format. You can format data labels in Excel if you choose to add data labels to a chart.

Excel add callout to chart