O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Data Labels

If you neglected to add data labels to your chart while you were working your way through the Chart Wizard, you can do so after the fact by selecting any part of the chart, choosing Chart, Chart Options, and clicking the Data Labels tab. You can also use the Data Labels tab of the Chart Options dialog box to modify the contents of your labels. The labeling options for most chart types are Series Name, Category Name, and Value (see Figure 24-5). In pie and doughnut charts, you can also display each point's percentage of the total points—a useful option.

If your chart has more than one series, asking for data labels in the Chart Wizard or the Chart Options dialog box creates labels for all your series. If you want to label ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required