Add or change captions, labels, and titles in PivotTable or PivotChart view

In PivotTable view

The changes you make don't affect the source data.

1. Open a datasheet or form in PivotTable view.
2. On the PivotTable toolbar, click Properties .
3. Do one or more of the following:

   Change the caption of a drop area

   1. In the Properties dialog box, click the Captions tab.
   2. In the Select caption list, select the element whose caption you want to change.
   3. In the Caption box, type the new caption.

   Change the caption of a field

   1. Click the field whose caption you want to change.
   2. In the Properties dialog box, click the Captions tab.
   3. In the Select caption list, select the element whose caption you want to change.
   4. In the Caption box, type the new caption.

   Change the caption of an item or custom group

   1. Click the item or custom group whose caption you want to change.

   2. In the Properties dialog box, click the Captions tab.

   3. In the Caption box, type the new caption.

Notes

• If you don't want a caption for the selected item, clear the Caption text box.

• On the Captions tab, selecting Report title bar in the Select caption list and typing a new caption or applying a format does nothing.

In PivotChart view

1. Open a datasheet or form in PivotChart view.

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. You can change data labels after you add them.

1. Select the data series to which you want to add data labels by clicking an individual data marker in the series. Click again to select the entire series.

2. On the PivotChart toolbar, click Properties , 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.

Remove data labels

1. Click the data label you want to remove.

   If you want to remove all data labels in a series, click a second time to select all data labels in the series.

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, and then click a second time to select all data labels in the series.

2. On the PivotChart toolbar, click Properties , 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, and then click a second time to select all data labels in the series.

2. On the PivotChart toolbar, click Properties , 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, and then click a second time to select all data labels in the series.

2. On the PivotChart toolbar, click Properties , 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, and then click a second time to select all data labels in the series.

2. On the PivotChart toolbar, click Properties , and then click the Border/Fill tab.

3. Select the options you want under Border and under Fill.

Add a title

1. Click the item in the chart to which you want to add a title ù for example, the chart workspace or an axis.

2. On the PivotChart toolbar, click Properties , and then click the General tab.

3. Click Add Title .

Remove a title

1. Click the title you want to remove.

2. Press DELETE.

Change a title

1. Click the title you want to change.

2. On the PivotChart toolbar, click Properties .

3. Do one or more of the following:

   Change the text format

   1. Click the Format tab.

   2. Select the options you want under Text format.

   Change the title position

   1. Click the Format tab.

   2. Under Position, in the Position box, click Top, Bottom, Left, or Right.

   Change the title contents

   1. Click the Format tab.

   2. Under Caption, type a new title in the Caption box.

   Change the border or fill color

   1. Click the Border/Fill tab.

   2. Select the options you want under Border and under Fill.