Subscribe in a readerPivottable Slicers
Introduction
Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article I'll discuss how you can put slicers to work.
Comments
All comments about this page:
Comment by: Melroy Beeks (11/6/2011 3:21:11 PM)In my Micro
soft does not have a SLICER button
Comment by: Jan Karel Pieterse (11/8/2011 12:53:15 AM)Hi Melroy,
You need to have Excel 2010 to be able to use Slicers in Pivot tables.
Comment by: Irvin Jaffe (3/7/2012 12:32:47 PM)RE: Excel 2010. I have a slicer with 6 choices. I want to show only 4 of the 6 (2 of the 6. And, of the 4 that I want visible, I want to change the text. How do I do this?
Comment by: Jan Karel Pieterse (3/8/2012 2:39:30 AM)Hi Irvin,
I think you can only achieve that by removing data from the source so that those items are not on the slicer. Also, you cannot change what is shown on the slicer, other than by changing the source data.
Comment by: ana (4/3/2013 1:03:44 PM)How do I change the order of the buttons in a slicer? I have A, B, C, and D buttons and i want to arrange them like C,B,D, A.
Comment by: Jan Karel Pieterse (4/3/2013 1:19:22 PM)Hi Ana,
I don't think you can change the order. I tried with an existing pivot table, but failed.
In the properties of the slicer you can set the sort order to be the same as in the data source. Perhaps that helps?
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.