Working with Data Labels

As you saw in Chapter 19, you can add data labels (annotations positioned on or near chart markers that indicate the value of data points) by clicking the Layout tab and then clicking Data Labels in the Labels group. The ensuing drop-down lists provide options about where to put the labels—inside or outside column markers, for example. The positioning options vary according to chart type, and in all cases you can adjust a label’s position by selecting it individually and then dragging its bounding rectangle.

Additional options concern the content of the data labels. These too vary by chart type (with pie charts, for example, you have the option of putting percentages in the data labels). To see what’s available for a chart, ...

Get Microsoft® Office Excel® 2007 Inside Out 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.