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

Microsoft Office Access 2003

previous page next page

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 Button image.
  3. Do one or more of the following:

    ShowChange 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.

    ShowChange 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.

    ShowChange 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.

ShowIn PivotChart view

  1. Open a datasheet or form in PivotChart view.

  2. Do one or more of the following:

ShowAdd 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 Button image, and then click the General tab.

  3. Click Add Data Label Button image.

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.

ShowRemove 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.

ShowChange data labels

ShowChange 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 Button image, 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.

ShowChange 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 Button image, and then click the Format tab.

  3. Select the options you want under Text format.

ShowChange 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 Button image, 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.

ShowChange 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 Button image, and then click the Border/Fill tab.

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

ShowAdd 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 Button image, and then click the General tab.

  3. Click Add Title Button image.

ShowRemove a title

  1. Click the title you want to remove.

  2. Press DELETE.

ShowChange a title

  1. Click the title you want to change.

  2. On the PivotChart toolbar, click Properties Button image.

  3. Do one or more of the following:

    ShowChange the text format

    1. Click the Format tab.

    2. Select the options you want under Text format.

    ShowChange the title position

    1. Click the Format tab.

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

    ShowChange the title contents

    1. Click the Format tab.

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

    ShowChange the border or fill color

    1. Click the Border/Fill tab.

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

previous page start next page