When creating Pivot Charts from PivotTables, the PivotTable fields will be displayed on the chart. In this tip, you’ll learn how to quickly hide them so that your report looks neater.
Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016.
You are welcome to download the workbook to practice this short, helpful tip.
To remove the Field items, select the Analyze tab under the PivotChart Tools section.
In the Show/Hide section, click on Field Buttons.
Once selected, the Fields are removed from the chart.
This is a quick and easy way to neaten up your Pivot Charts and ensure that your reports are sleek and readable.