How to Hide or Show Field Buttons in Pivot Chart

After you create a Pivot Chart, you may need to hide the field buttons. please follow the steps below to hide the field buttons:

Step 1: Right-click on the field button that you want to hide, e.g., "Sum of Income";

Step 2: Click "Hide Value Field Buttons on Chart" from the drop-down list to hide the field button;

If you want to hide all field buttons in the pivot chart, click "Hide All Field Buttons on Chart".

Alternatively, please follow the steps below to hide or show the field buttons in the pivot chart:

Step 1: Click anywhere in the chart and you will see the "Analyze" tab in the ribbon. Click the "Analyze" tab;

Step 2: Click the "Field Button" command in the "Show/Hide" section;

Step 3: Click "Show Axis Field Button" or "Show Value Field Button" from the drop-down list.

Leave a Reply