Add Slicers to PivotCharts (Tutorial)

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on

Slicers are one-click filtering controls that narrow the portion of a data set shown in PivotTables and PivotCharts. Slicers can be used in both Microsoft Excel workbooks and PowerPivot workbooks, to interactively filter and analyze data.

In this task you will use PowerPivot Slicers to control what data appears in your PivotChart.


This topic is part of a PowerPivot for Excel tutorial, which should be completed in order. For information about prerequisites and the first step in the tutorial, see PowerPivot for Excel Tutorial Introduction.

To Add Slicers to a PivotChart

  1. Click anywhere inside the Profit % by Category PivotChart to display the PowerPivot Field List.

  2. In the PowerPivot Field List, locate the DimDate table.

  3. Drag CalendarYear and CalendarQuarter to the Slicers Horizontal area of the PowerPivot Field List.

  4. Under the Geography table, select ContentinentName.

  5. To the Slicers Vertical area of the PowerPivot Field List.

To Format Slicers

  1. Arrange the Slicers so that they can all be seen. To move the Slicers, click the gray border and drag the Slicers.

  2. By default, Slicer items are displayed in alphabetical and numeric order, with items with no data displayed last. To change this view:

    1. Right-click the CalendarYear Slicer, and select Slicer Settings.

    2. Uncheck Show items with no data last. Click OK.

  3. Continue to format your Slicers as needed.

To Use Slicers to Analyze your PivotChart Data

  1. Use the CalendarYear Slicer to explore profit by year. The PivotChart clearly shows the profit share increase for COMPUTERS and TV and VIDEO (at the expense of CAMERAS and CAMCORDERS) from 2007 to 2009. Profit share for the other categories shows almost no fluctuation.

  2. To dig even deeper, use the CalendarMonth Slicer. You will discover that CAMERAS and CAMCORDERS had the highest profit share in the latter months of 2007**.**

Next Step

In the next lesson, Create a Measure and KPI (Tutorial), you will learn how to use formulas to create visual reports that communicate business performance metrics at a glance.

See Also


Filter Data Using Slicers