PDA

View Full Version : Loop through slicers in PivotTable/PivotChart and export to PowerPoint?



waimea
04-01-2020, 09:26 AM
Hi, I have a PivotChart with two slicers, year and month,

is it possible to loop through all possible slicer values and export the current slicer selection to PowerPoint?

Ex. year is 2019 and months are nov and dec and year is 2020 and months are jan, feb and mar?.

This would give me 5 charts in 5 PowerPoint slides.

waimea
04-02-2020, 02:23 AM
After googling I found that is is possible to loop through slicers.

I want to loop through my two slicers, named "Year" and "Month".

I donīt understand how slicers and slicercache works?