Microsoft Office Tutorials and References
In Depth Information
Working with Data Labels
Adding or removing gridlines
To add or remove gridlines, activate the chart and click the Chart Elements button next the chart.
This will expand a menu of chart elements you can add to your chart. Place a check next to Gridlines
to add gridlines. Remove the check to remove gridlines.
Each axis has two sets of gridlines: major and minor. Major units are the ones that display a label.
Minor units are those in between the labels. If you’re working with a chart that has a secondary
category axis, a secondary value axis, or a series axis (for a 3-D chart), the dialog box has additional
options for three sets of gridlines.
A more direct way to remove a set of gridlines is to select the gridlines and press Delete.
If a chart uses a secondary axis, you can specify either or both value axes to display
gridlines. As you might expect, displaying two sets of gridlines in the same direction can
be confusing and result in additional clutter.
Note
To modify the properties of a set of gridlines, select one gridline in the set (which selects all in the
set) and access the Format Gridlines dialog box. Or, use the controls in the Chart Tools➜Format➜
Shape Styles group.
You can’t apply different formatting to individual gridlines within a set of gridlines. All
gridlines in a set are always formatted identically.
Note
Working with Data Labels
For some charts, you may want to identify the individual data points in a series by displaying data
labels.
Adding or removing data labels
To add data labels, activate the chart and click the Chart Elements button next the chart. This will
expand a menu of chart elements you can add to your chart. Place a check next to Data Labels.
To remove data labels from a particular series, select the data labels and press Delete. To remove a
single data label, click the individual label once to select the series data labels; then click the
individual label again. This will ensure that only the targeted label is selected. At this point, you can
press Delete.
If an entire chart series is selected, data labels will be added to the selected series. If a
single point is selected, a data label will be applied to only to the selected point. If a
chart element other than a series (or single point) is selected, Excel adds data labels to
all series in the chart.
Note
Search JabSto ::




Custom Search