Page 551 - Excel 2013 All-in-One For Dummies

Worksheet Charting 101 533
Figure 1-9:
Repositioning the chart title in the example clustered column using the Chart Element button’s menus.
Adding data labels to the series in a chart
Data labels identify the data points in your chart (that is, the columns, lines, and so forth used to graph your data) by displaying values from the cells
of worksheet represented next to them. To add data labels to your selected chart and position them, click the Chart Elements button next to the chart and then select the Data Labels check box before you select one of the fol- lowing options on its continuation menu:
✦ Center to position the data labels in the middle of each data point
✦ InsideEndtopositionthedatalabelsinsideeachdatapointneartheend
✦ Inside Base to position the data labels at the base of each data point
✦ Outside End to position the data labels outside of the end of each data point
✦ Data Callout to add text labels and as well as values that appear within text boxes that point to each data point
✦ More Options to open the Format Data Labels task pane on the right side where you can use the options that appear when you select the Fill & Line, Effects, Size & Properties, and Label Options buttons under Label Options and the Text Fill & Outline, Text Effects, and Textbox buttons under Text Options in the task pane to customize almost any aspect of the appearance and position of the data labels
Book V Chapter 1
Charting Worksheet Data