Data labels show the numeric values (or other information) that are represented by each bar or other shape on the chart. These labels are useful when the exact numbers are important or where the chart is so small that it is not clear from the axes what the data points represent.

To turn on data labels for the chart, click the Data Labels button on the Layout tab. The options available depend on whether it’s a 2-D or 3-D chart. Figure 23-44 shows the options for 2-D charting; for a 3-D chart your only choices are Show and None.

FIGURE 23-44
You can display or hide data labels using the Data labels button.

Data labels show the values by default, but you can also set them to display the series name and the category name, or any combination of the three. The data labels can also include the legend key, which is a colored square. To set these options, choose More Data Label Options from the Data Labels drop-down menu, to access the Format Data Labels dialog box, as shown in Figure 23-45. For a 3-D chart, the Label Position section does not appear.

FIGURE 23-45
You can set data label options using the Format Data Labels dialog box.

To turn the data labels on or off for a particular data point or data series, select it and then select the None or Show option in the Data Labels drop-down menu. This is useful when you want to highlight a particular value or set of values.

• Show Barry nice chance in Moonee Valley Cup Show Barry looks a nice chance in the 2500m Moonee Valley Cup, the class runner in a lack-lustre field. Nice...
• Interracial marriage still rising, but not as fast [/caption] WASHINGTON – Melting pot or racial divide? The growth of interracial marriages is slowing among U.S.-born Hispanics and Asians....
• A Free Retirement Checkup from a Financial Advisor For anyone looking for a quick checkup of their retirement planning to see if they are on track for the...
• How to Find IP Address on Computer [/caption]Each and every device that is connected to internet is associated with a unique number which is referred to as...
• Avoid Foreclosure Chart Clearly Shows Short Sale Benefits! Avoid foreclosure chart below clearly conveys the benefits of short sale (IF) your situation permits. What's best for you depends...