Show All

Add, remove, or change data labels

1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. Do one or more of the following:

   Add data labels

   The chart type associated with the selected data series or data point determines the type of data labels that can be added.

   1. Select the data series to which you want to add data labels.

   2. On the toolbar, click Commands and Options , and then click the General tab.

   3. Click Add Data Label .

   Note   You cannot add a data label to a single data point. However, after adding data labels to a series, you can select and delete individual data labels that you do not want to display. To select an individual data label, click once on a data label to select all the labels in the series, and then click a second time on the individual data label you want to delete.

   Remove data labels

   1. Click a data label in the set of data labels you want to remove.

   2. Press DELETE.

   Change data labels

   Change the contents of data labels

   1. Click a data label in the set of data labels you want to change.
   2. On the toolbar, click Commands and Options , and then click the Data Labels tab.
   3. Under Data Label, select one or more of the following that you want shown in the data label: Category name, Value, Series name, Bubble size (available for bubble charts only), or Percentage.
   4. If you select more than one of the above items to show in your data labels, you can separate each with a comma or space, or put each on a separate line. To do so, click the option you want in the Separator list.

   Change the text format of data labels

   1. Click a data label in the set of data labels you want to change.
   2. On the toolbar, click Commands and Options , and then click the Format tab.
   3. Select the options you want under Text format.

   Change the position of data labels

   1. Click a data label in the set of data labels you want to change.
   2. On the toolbar, click Commands and Options , and then click the Data Labels tab.
   3. Under Data Label, click the location in the Position list where you want the data labels to appear in relationship to the data markers. For example, click Inside Base to show data labels inside and at the bottom of data markers in a standard column chart.

   Change the border or fill for data labels

   1. Click a data label in the set of data labels you want to change.
   2. On the toolbar, click Commands and Options , and then click the Border/Fill tab.
   3. Select the options you want under Border and under Fill.