Adding data labels in Microsoft Excel 2019

To make a chart more understandable and easily readable for the user,data labels are necessary. In the following example, a pie chart existswithout data labels:

  1. Select the pie chart in the workbook.
  2. From the Design tab, clickon the Add Chart Elementicon.
  1. Locate the Data Labels category,and then select an option from the drop-down list.
  2. Choose the label type, after which the chart updates.
  3. Click on a data label (this will select all data labels).
  4. To make formatting changes to the labels, use the formatting iconson the Format tab, located on theChart Tools contextual menu.

Leave a Comment