In a previous post I showed you how to Insert a Pivot Chart.  Now we will take this concept once step further and insert a Slicer.  The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart.

See how you can start creating some awesome interactive analytical reports in just a couple of steps.



Here we have our Pivot Table and Pivot Chart ready:

STEP 1: Click in your Pivot Table and go to Options > Insert Slicer


STEP 2: Select Region and Year. Click OK

You now have your Slicer and you can play around with it! It will affect both the Pivot Table and Pivot Chart!

Pivot Charts & Slicers

Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0! This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text. To activate this you need to Right Click in any Value i...
Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables. The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like: DIRECTIONAL (Change in valu...
Conditional Format a Cell´s Value A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules. Formatting cells that contain a specific criteria, for example, greater than X or less than X, is a good way to visualize your results. When your criteri...
Pivot Table Calculated Field Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%. The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate p...