Add labels to help clarify the presentation of your data. Some options are not available for some graphs. For example, you cannot label the bars of a histogram with row numbers from the worksheet.

Common data label options

Label the data display with y-values, row numbers, or values from a column. For example, the bars on the following histogram are labeled with the exact frequency value for each bar.

To add data labels when you create a graph, click Labels, then click the Data Labels tab. To add data labels to an existing graph, click the graph and choose Editor > Add > Data Labels.

To edit data labels, select and double-click the labels that you want to edit. For more information on selecting labels, go to Select groups and single items on a graph.

On the Font tab, you can change the color, style, size, and font for the labels. You can also change the text of individual data labels.

Label Type

On the Data Labels tab, you can choose one of the following types of data labels.

Use y-value labels
Label symbols or bars with the corresponding y-axis value.

The labels on this histogram show the y-value (frequency) for each bar.

The symbols on this scatterplot show the y-value for each observation.

Use row numbers
Label symbols with the corresponding row numbers from the worksheet. For example, each label in the following bubble plot shows the row number for the corresponding observation in the worksheet.
C1 C2 C3
X Y Size
6.8 2.5 9.5
9.7 9.5 1.2
9.0 3.3 8.5
... ... ...
Use labels from column
Label symbols or bars with values from a column. For example, the labels on the following bar chart are from the Fuel Labels column.
C1 C2 C3
Combined MPG Fuel Fuel Labels
19.25 1 Gas
39.55 2 Hybrid
25.50 1
41.20 2
... ...

Placement of data label

On the Alignment tab, you change the following.

Text angle
Rotate the labels. For example, rotating the labels on this time series plot by 35 degrees makes it easier to read adjacent labels.
Text angle = 0 (default)
Text angle = 35
Position
Change the position of the label relative to the anchor point. Under Position, choose Custom, then choose a position. The following examples show 3 of the available positions.
Above (default)
Above, to the left
Below, to the right
Offset
Move the label horizontally or vertically relative to its current position. Under Offset, choose Custom, then specify the horizontal or vertical distance to move the label.
Horizontal 0, Vertical 0 (default)
Horizontal –0.05, Vertical –0.05
Horizontal 0.05, Vertical 0.05

Options specific to boxplots, interval plots, and individual value plots

Label one or more data display elements with y-values, row numbers, or values from a column. For example, the outliers in the following boxplot are labeled with the corresponding row number. The median lines are labeled with the medians (y-values).

To add data labels when you create a graph, click Labels, then click the Data Labels tab and choose the data element to label and the type of label. After you create the graph, you can add labels for additional data elements. Click the graph and choose Editor > Add > Data Labels, choose the tab for the data element that you want to label, and choose a label type.

Options specific to pie charts

Label pie slices with category names, frequencies, or percentages. You can also draw a line from the label to the slice. For example, the following pie chart shows the number of credit cards that are held by survey respondents. The labels show the percentages for each slice. The lines help associate the labels with their respective slices.

To add data labels when you create a graph, click Labels, then click the Slice Labels tab. To add data labels to an existing graph, click the graph and choose Editor > Add > Slice Labels.

Slice labels and leader lines

On the Slice Labels or Show tab, you can choose from the following label options.

Label Type
You can add any or all of these label types to your pie chart. The category name is the value of the categorical variable that is associated with each slice.
Category name
Frequency
Percent
Show leader lines
To show the leader lines, select Show leader lines or Draw a line from label to slice, depending on which dialog box you are using. To edit the appearance of the leader lines, double-click a label. On the Leader Lines tab, you change the type, color, or size of leaders lines.
Not selected (default)
Selected

Options specific to marginal plots

When you create a marginal plot with histograms, you can label the bars of the histogram to show the frequency for each bin. In the dialog box, click Labels. On the Histogram Labels tab, select Label histogram bars with y-value.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy