This is a Chart-Pro’s tip!
You can instead use Slicers as Selection Buttons!
If you already know about slicers then you must be aware that slicers are applied in a pivot table or a normal table which can slice or dice the data
But you can also use them without making a “real” pivot table… well almost! I can’t explain any better if I don’t show you an example.. so let’s get right into it
The Problem is – that unless you explicitly mention it somewhere, no user will self get to know that there is a products drop down placed to change between the products
Solution – Well if you are not a formatting freak.. this problem won’t even move the needle for you. I am, and I know a lot of people who are formatting geeks and keeping in mind that you’ll be one of us someday.
I propose to replace the drop down with a slicer for selecting the product. Why? Because slicers are more intuitive and classy
To do that
You’ll just have one field because we just selected a single column.. which is exactly what we want
Now when you click on the slicer.. you’ll see the pivot changing
In case you have been wondering that my slicer looks different than what I created in the first place. It is because I formatted it to make it look pretty (coz I am a formatting fanatic). Read about Slicer formatting in detail
By now I am sure you are waiting to DOWNLOAD THE EXCEL FILE