Friday, August 10, 2012

Excel Pivot Table Slicers: be excited!

This post has a two fold aim:

embedding an Excel file in a blog post
showing you how Pivot Table Slicers could change your life

Look at the work sheet that follows!

As far as I can tell, the embedded worksheet that you see below is not interactive in this post so ... Click on the icon in the bottom right hand corner of the embedded file here ... View full size workbook: you will see the whole Excel file then and it IS interactive.

Click on the buttons in the work sheets ... select two or more buttons by ctrl+left click ... then watch the way the chart changes ... take a look at the linked Pivot Table too ... it changes as you select and deselect the buttons ... click on the slicer buttons and see what happens to the Chart! The chart looks terrible when this file first opens ... it's meant to as it's all part of the effect!!


Feedback??
DW

No comments:

Post a Comment