Format data labels in a chart in Office 2016 for Mac

Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. You can format the labels to show specific labels elements like, the percentages, series name, or category name.

Pie chart with data labels formatted as percentages

  1. To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options.

    Office for Mac Chart Add Elements
  2. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.

    Office for Mac Format Data Labels

See Also

Create a chart in Word or PowerPoint for Mac

Create a chart in Excel

Filter data from your chart

Change chart type

Add data series in charts

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×