Based on the provided reference, the steps you can take describe how to change a specific layout setting within the PivotTable, which can be associated with a Pivot Chart. This setting allows you to control the merging and centering of cells containing item labels in the PivotTable structure itself.
Here's how to change the 'Merge and center cells with labels' layout option in your PivotTable:
To adjust how labels are displayed within your PivotTable, specifically regarding merging and centering cells, follow these steps:
- Select the PivotTable: Click anywhere within the PivotTable connected to your chart. This action will activate the PivotTable Tools tabs (Analyze/Options and Design) on the Excel ribbon.
- Access PivotTable Options: On the Options tab (or Analyze tab, depending on your Excel version) under PivotTable Tools, locate the PivotTable group. Click on the Options button within this group.
- Adjust Layout Settings: The PivotTable Options dialog box will open. Click on the Layout & Format tab. In the Layout section of this tab, find the Merge and center cells with labels check box.
- Select the check box if you want labels for outer row and column items to be merged across the cells they occupy and centered within that merged range.
- Clear the check box if you prefer the labels to appear in only the first cell of the item range without merging.
This setting primarily impacts the visual presentation of the row and column labels within the PivotTable grid.
