Skip to main content

Specifying New Captions

Specifying New Captions

To specify new captions:

  1. Click the Advanced Options button next to the item or in the header of the Rows or Columns box, as appropriate.

    See Customizing Pivot Table Items.

  2. Type a value into Caption.

    To include the original name in the caption, use an asterisk (*) at the appropriate position.

  3. Click OK.

For example:

labels are group:0 to 29, group:30 to 59, group:60+

In this case, Caption is Group: *

FeedbackOpens in a new tab