Add Data Labels

Data labels provide information about data in a chart. Although this chart includes a color-coded legend, we'll provide additional information about the three biggest expenses using data labels.

Click the pie piece for Rent. If the entire chart becomes selected, click it again so only the Rent piece is selected.

Double-click the selected pie piece.

The Format Data Point dialog appears.

Important Note: If the Format Data Series

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.