Which Of The Following Is Not An Option That The Data Labels Can Produce?

Data labels make a chart easier to understand because they evidence details about a information serial or its private data points. For instance, in the pie chart below, without the information labels information technology would be hard to tell that coffee was 38% of total sales. Depending on what you lot want to highlight on a nautical chart, you tin add labels to one serial, all the series (the whole nautical chart), or one information indicate.

Pie chart with data labels formatted as percentages

Notation:The following procedures utilize to Office 2013 and newer versions. Looking for Office 2010 steps?

Add data labels to a chart

Click the data series or chart. To label one information point, later on clicking the series, click that data point.
In the upper right corner, next to the nautical chart, click Add together Chart Chemical element > Data Labels.
To change the location, click the arrow, and cull an option.
If yous desire to evidence your data label inside a text bubble shape, click Information Callout.

To make data labels easier to read, yous can move them inside the data points or fifty-fifty outside of the chart. To move a data characterization, drag information technology to the location y'all want.

If you decide the labels make your chart expect too cluttered, you can remove any or all of them by clicking the data labels and then pressing Delete.

Tip:If the text inside the data labels is too difficult to read, resize the information labels by clicking them, and then dragging them to the size you lot desire.

Change the expect of the data labels

Right-click the data series or data label to display more than information for, and then click Format Data Labels.
Click Label Options and under Characterization Contains, pick the options you desire.

Employ cell values as data labels

You lot can employ cell values every bit data labels for your chart.

Right-click the data series or data characterization to brandish more data for, and then click Format Information Labels.
Click Label Options and under Label Contains, select the Values From Cells checkbox.
When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to brandish as information labels. When y'all practice that, the selected range volition announced in the Information Label Range dialog box. And so click OK.

The cell values will now display as data labels in your nautical chart.

Change the text displayed in the information labels

Click the data label with the text to modify and so click it again, then that information technology's the only data label selected.
Select the existing text and then type the replacement text.
Click anywhere outside the information label.

Tip:If you want to add a comment almost your chart or have only one data label, y'all can use a textbox.

Remove information labels from a chart

Click the chart from which you desire to remove data labels.

This displays the Nautical chart Tools, adding the Design, and Format tabs.
Do one of the following:
- On the Design tab, in the Chart Layouts group, click Add together Chart Chemical element, choose Information Labels, and so click None.
- Click a data characterization one time to select all data labels in a data series or two times to select simply one data characterization that y'all desire to delete, then press DELETE.
- Right-click a data label, and then click Delete.
  
  Note:This removes all data labels from a data series.
You can also remove data labels immediately after you add them past clicking Undo on the Quick Access Toolbar, or past pressing CTRL+Z.

Add or remove data labels in a nautical chart in Role 2010

On a chart, practice one of the post-obit:
- To add a data label to all data points of all data series, click the chart surface area.
- To add a data label to all data points of a information serial, click one time to select the data series that you want to label.
- To add a data label to a single data point in a data series, click the data serial that contains the data signal that y'all desire to label, and and so click the information betoken again.
  
  This displays the Chart Tools, adding the Blueprint, Layout, and Format tabs.
On the Layout tab, in the Labels group, click Data Labels, and then click the display choice that you want.

Depending on the chart type that you used, unlike information characterization options will be bachelor.

On a chart, do one of the following:
- To brandish additional label entries for all information points of a serial, click a information label 1 time to select all data labels of the data series.
- To display additional label entries for a single data bespeak, click the information label in the data point that you want to change, then click the data label again.
  
  This displays the Chart Tools, adding the Design, Layout, and Format tabs.
On the Format tab, in the Current Selection group, click Format Option.

You tin can likewise correct-click the selected label or labels on the chart, and then click Format Data Characterization or Format Information Labels.
Click Label Options if information technology'southward not selected, so nether Label Contains, select the check box for the label entries that you want to add.

The label options that are available depend on the chart type of your nautical chart. For example, in a pie chart, information labels can comprise percentages and leader lines.
To change the separator betwixt the data label entries, select the separator that yous want to use or type a custom separator in the Separator box.
To suit the label position to better present the boosted text, select the option that you want under Label Position.

If yous have entered custom label text just want to display the data label entries that are linked to worksheet values again, you can click Reset Characterization Text.

On a chart, click the data characterization in the data point that y'all want to modify, and and so click the data characterization again to select only that characterization.
Click inside the data label box to start edit mode.
Do ane of the following:
- To enter new text, drag to select the text that yous want to alter, and and then type the text that you desire.
- To link a information label to text or values on the worksheet, drag to select the text that you lot want to modify, and then practice the following:
  1. On the worksheet, click in the formula bar, and so type an equal sign (=).
  2. Select the worksheet prison cell that contains the data or text that you want to display in your nautical chart.
    
    Yous can also type the reference to the worksheet jail cell in the formula bar. Include an equal sign, the canvas name, followed past an assertion indicate; for instance, =Sheet1!F2
  3. Printing ENTER.
    
    Tip:Y'all can use either method to enter percentages — manually if you know what they are, or by linking to percentages on the worksheet. Percentages are non calculated in the chart, but you can summate percentages on the worksheet by using the equation amount / total = percentage. For example, if you calculate 10 / 100 = 0.ane, so format 0.i as a percent, the number will exist correctly displayed as 10%. For more information virtually how to calculate percentages, see Calculate percentages.

The size of the data label box adjusts to the size of the text. You cannot resize the data label box, and the text may go truncated if information technology does not fit in the maximum size. To accommodate more than text, yous may want to utilise a text box instead. For more data, encounter Add together a text box to a chart.

You can change the position of a single data label by dragging it. You can besides identify data labels in a standard position relative to their data markers. Depending on the chart blazon, you can cull from a variety of positioning options.

On a chart, do one of the following:
- To reposition all data labels for a whole data series, click a data label one fourth dimension to select the data series.
- To reposition a specific data label, click that data label ii times to select it.
  
  This displays the Chart Tools, adding the Pattern, Layout, and Format tabs.
On the Layout tab, in the Labels group, click Data Labels, and and so click the option that you want.

For additional data label options, click More Data Label Options, click Characterization Options if it's non selected, and and then select the options that you want.

Click the nautical chart from which y'all want to remove information labels.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.
Do ane of the following:
- On the Layout tab, in the Labels group, click Data Labels, and and so click None.
- Click a information label one time to select all information labels in a information series or 2 times to select just one information characterization that y'all want to delete, and and so press DELETE.
- Correct-click a data label, and and so click Delete.
  
  Annotation:This removes all data labels from a data serial.
You tin can also remove data labels immediately subsequently you add together them by clicking Undo on the Quick Access Toolbar, or by pressing CTRL+Z.

Data labels make a chart easier to understand because they prove details about a information series or its individual data points. For example, in the pie chart below, without the information labels it would be hard to tell that coffee was 38% of full sales. Depending on what y'all want to highlight on a chart, you lot tin can add together labels to one series, all the serial (the whole chart), or i data point.

Add data labels

Yous tin add together information labels to evidence the data indicate values from the Excel sheet in the chart.

This step applies to Word for Mac only: On the View menu, click Impress Layout.
Click the nautical chart, then click the Nautical chart Blueprint tab.
Click Add Chart Element and select Data Labels, and and then select a location for the information label pick.

Note:The options will differ depending on your chart type.
If you want to show your data label inside a text chimera shape, click Data Callout.

To make information labels easier to read, yous tin move them inside the data points or even exterior of the chart. To move a data label, elevate it to the location you want.

Note:If the text within the data labels is too hard to read, resize the data labels by clicking them, then dragging them to the size you desire.

Click More Data Label Options to alter the look of the data labels.

Change the look of your data labels

Right-click on whatsoever data label and select Format Data Labels.
Click Label Options and under Characterization Contains, choice the options you want.

Change the text displayed in the data labels

Click the data characterization with the text to change so click it again, so that it's the only information characterization selected.
Select the existing text and so blazon the replacement text.
Click anywhere exterior the data label.

Tip:If you want to add a annotate virtually your chart or have simply one data label, you lot can use a textbox.

Remove information labels

If you determine the labels make your nautical chart await too cluttered, you can remove whatsoever or all of them by clicking the information labels and so pressing Delete.

Note:This removes all data labels from a data series.

Use cell values as information labels

You tin can use prison cell values as information labels for your chart.

Right-click the data serial or data label to display more than information for, and so click Format Data Labels.
Click Characterization Options and under Label Contains, select the Values From Cells checkbox.
When the Data Characterization Range dialog box appears, go back to the spreadsheet and select the range for which you want the jail cell values to display as data labels. When you do that, the selected range will appear in the Data Label Range dialog box. Then click OK.

The cell values will now display as data labels in your chart.