hello. can someone please advice me something regarding the slicers in excel 2013?
i have a slicer that shows the years in my data. its 2011 - 2015, which the slicer is programmed to.
and im asked if theres a way to only show the year 2012 - 2016 for next year, if i happen to add 2016 data in next year.
which means i have to hide the '2011' data from the slicer but it has data in 2011.
because he doesnt want to see all the years in the slicers if he wants to continously add in data.
please help!
i have a slicer that shows the years in my data. its 2011 - 2015, which the slicer is programmed to.
and im asked if theres a way to only show the year 2012 - 2016 for next year, if i happen to add 2016 data in next year.
which means i have to hide the '2011' data from the slicer but it has data in 2011.
because he doesnt want to see all the years in the slicers if he wants to continously add in data.
please help!
