Microsoft Office Tutorials and References
In Depth Information
Adding and positioning data labels
Here you could select month names, click Edit, and supply the shortened versions you
Adding and positioning data labels
You can add data labels to all series in a chart by selecting the chart, clicking the Chart
Elements button, and selecting the Data Labels check box. The submenu includes a set of
positioning options geared to the type of chart. With some charts, you might find a Best Fit
option; as Figure 19-2 shows, this option can be handy on pie charts with narrow slices.
Figure 19-2 If you choose Best Fit for this chart’s data labels, Excel doesn’t try to it the label
2383 into the narrow slice but displays it outside the pie instead.
Adding a data table
A data table is a copy of your source data included within the chart. Data tables are useful
particularly when the chart and its underlying data are not in close proximity on the
worksheet or when you intend to copy the chart to a Microsoft Word or PowerPoint document.
To add a data table, select the chart, click the Chart Elements button, and select the Data
Table check box. You can use the available options to choose between having and not
having legend keys with your table.
Adding and removing gridlines
To add or remove gridlines, click the Chart Elements button and select or clear the Gridlines
check box. The submenu that appears when you click the arrow to the right of the Gridlines
check box gives you iner control; for each axis on the chart, you can select either major
gridlines, minor gridlines, or both. Excel previews the effects of these choices as you hover
the mouse pointer over the check boxes.
Search JabSto ::

Custom Search