'Field" is misspelled as "Filed". I just thought you should know.
When creating a Pivot Chart in Excel, the Report Filter field buttons, Legend field buttons, Axis Field buttons, and Value Field buttons are added into the Pivot Chart automatically as below screen shot shown. As these buttons take space and make the global layout messy, some users may want to hide them. This article will show you the way to show or hide field buttons in a Pivot Chart in Excel easily.
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To show or hide field buttons in pivot chart in Excel, please do as follows:
Step 1: Click the Pivot Chart that you want to hide/show field buttons to activate the PivotChart Tools in Ribbon.
Step 2: Under the Analyze tab, click the field Buttons to hide all field buttons from selected Pivot Chart.
(1) Click the field Buttons once again, all field buttons will be shown in selected Pivot Chart again.
(2) To hide/show a kind of field buttons, such as Axis Field buttons, click the arrow at the bottom-right corner of Field Buttons, and then uncheck/check the Axis Field Button from the drop down list.
Get back to the Pivot Chart, you will see all field buttons or specific kind of field buttons are hidden (or shown) from the Pivot Chart.
Note: In Excel 2007, field buttons are not added into Pivot Chart, and users can't add and show field buttons into Pivot Chart too.