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. When you then start choosing options in the ‘ Format Data Label‘ pane, labels will be added to all the data points.You can format data labels in Excel if you choose to add data labels to a chart. above, if you right-click on the label rather than the data point, the option is to ‘Format data label S‘ – i.e. To format the font, color and size of the label, now right-click on the label and select ‘ Font‘.
series name, category name, value, leader line), the position (right, left, above, below) in the Format Data Label pane/dialog box. You can now configure the label as required - select the content of the label (e.g.This is the key step! Right-click again on the data point itself (not the label) and select ‘ Format data label‘.Right-click and select ‘ Add data label‘.Click again on the single point that you want to add a data label to.All the data points will be highlighted.Click on the chart line to add the data point to.Method - add one data label to a chart line Steps shown in the video above: