Microsoft® Office Excel 2003 Inside Out

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 ...