I use Excel 2007 and when I insert a slicer into one of my pivot charts, it has buttons that I don't want. The buttons have no data that would applie to them and when you click on them, no data shows up.
Any help removing them would be appreciated.
Here is a screen show of the slicer to show what I mean. Untitled.png
Thanks for your help!
Bookmarks