Pivot Chart Tips
Charts and Visualization

3 Useful Tips for the Pivot Chart

In this article, you will learn 3 useful tips for Pivot Chart. Using these tips you can create an interactive Excel Dashboard.

Learn and download interactive Excel Dashboard free of cost-

Add the fields in Axis and Values
To add the Pivot Chart in Excel just select the data and go to chart Insert tab >> Pivot Chart. You can insert the pivot chart on the new worksheet or existing worksheet.

Insert a Pivot Chart
Insert a Pivot Chart

Add the fields in Axis and Values in Pivot chart-

Add the fields in Axis and Values

Below is the list of useful Pivot Tips:

Tip #1: Add Expand/Collapse button on the Chart:

We can add a expand and collapse button on a Pivot chart so that we can expand the chart to the next level hierarchy.
For example- we can show the Agent and Supervisor wise chart or Year and Quarter-wise chart.

Expand and collapse button on a Pivot chart
Expand and collapse button on a Pivot chart

To add this expand/collapse button you can follow the below steps-

  • Select the Pivot Chart and go to the PivotChart Analyze.
  • Go to the Fields Buttons.
  • Check the Expand/Collapse Entire Field Buttons
Add Expand/collapse button
Add Expand/collapse button

Tip #2: Add Filter Buttons on the chart

Filter buttons are useful to filter the data on the chart. These buttons can be available on the Chart.

Filter Buttons on the chart
Filter Buttons on the chart
  • You can add the Filters box in Pivot Charts Fields
  • In the Field Buttons, Check the Show Report Field Buttons
Add Filter Buttons on the chart
Add Filter Buttons on the chart

 

Tip #3: Connect with the Slicer

  • Select the Pivot Chart and go to the PivotChart Analyze.
  • Click on Insert Slicers
  • Select the Field name in the Insert Slicers window.

 

Connect with Slicers
Connect with Slicers

edding code

Watch the step by step video tutorial:

Click here to download the practice file.

 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com