Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
Adding data labels
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
the 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
following options on its continuation menu:
Center to position the data labels in the middle of each data point
Inside End to position the data labels inside each data point near the end
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 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
Adding data tables
Sometimes, instead of data labels that can easily obscure the data points in
the chart, you’ll want Excel to draw a data table beneath the chart showing
the worksheet data it represents in graphic form.
To add a data table to your selected chart and position and format it, click the
Chart Elements button next to the chart and then select the Data Table check
box before you select one of the following options on its continuation menu:
With Legend Keys to have Excel draw the table at the bottom of the
chart, including the color keys used in the legend to differentiate the
data series in the first column
No Legend Keys to have Excel draw the table at the bottom of the chart
without any legend
More Options to open the Format Data Table task pane on the right side
where you can use the options that appear when you select the Fill &
Line, Effects, Size & Properties, and Table Options buttons under Table
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 data table
Search JabSto ::




Custom Search