Create Dynamic Excel Pivot Table Dashboard with Slicers

Share Now

In Excel 2010 and 2013, you can insert slicer to filter pivot tables and pivot charts. In 2013 you can also quickly filter the Tables from Slicers.

Sales Dashboard

Click here to download the workbook template

Steps to Create the Dashboard with Pivot Table and Slicer

Create Pivot Table

• Select any cell in your existing data, click on the Insert Tab, Under Tables Panel, Click Pivot Table


Pivot table slicer2

Create Pivot Chart

• Select Existing Pivot table, click on the Analyze Tab, Under Tools Panel, Select Pivot Chart

Pivot table Slicer3

Now time to insert slicer for Pivot Table and Pivot Chart as both created.

Steps to create Slicer in Pivot Table

• Select any cell in the existing pivot table
• In Excel 2010 > Click on the Options tab > In the Sort & Filter group > click Insert Slicer.
In Excel 2013 > Click on the Analyze tab > In the Filter group > click Insert Slicer.

Pivot table Slicer4

• In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.
• Click OK.

You can also change the look and appearance of you slicer. To Change it, select slicer, click on the Options Tab, and select the design from the slicer style panel.

Share Now
November 15, 2019

0 responses on "Create Dynamic Excel Pivot Table Dashboard with Slicers"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


    0124- 4601426


    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED