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 .
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.
On the Data Labels tab, you can choose one of the following types of data labels.
|Combined MPG||Fuel||Fuel Labels|
On the Alignment tab, you change the following.
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 , choose the tab for the data element that you want to label, and choose a label type.
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 .
On the Slice Labels or Show tab, you can choose from the following label options.
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.