• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 some series but not all, first create your chart without labels. Then select the series you want to label, choose Format, Selected Data Series, and click the Data Labels tab. You'll find the same options there as in the Chart Wizard or the Chart Options dialog box. The only drawback to adding labels this way is that you can't see your labels until you leave the dialog box. (In the Chart Wizard or Chart Options dialog box, your selections take effect immediately—and that can be particularly useful if you're not sure what the various labeling options do.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint