Consulting

Results 1 to 2 of 2

Thread: Loop through slicers in PivotTable/PivotChart and export to PowerPoint?

  1. #1
    VBAX Contributor
    Joined
    Jul 2018
    Posts
    174
    Location

    Loop through slicers in PivotTable/PivotChart and export to PowerPoint?

    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.

  2. #2
    VBAX Contributor
    Joined
    Jul 2018
    Posts
    174
    Location
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •