Hello,

I am stuck with a complex situation.

I have 78 Excel Pivot Charts in an Excel.
I need to extract them in a PowerPoint Slide as Image but every slide should have 6 charts only and that group of 6 charts needs to have a Header on top of it.

I have referred to SigmaCoding videos (on YouTube) and his GitHub code, but unable to crack the logic for macro in this case.

The charts are of same size and are aligned. So, I am trying to group the 6 charts and then extract that group in a PPT slide and have a header for that Slide.

The headers are static so if we can copy the group of charts in a existing PPT template that would work too.

Can anyone please help me with this? Stuck since 1 week with this use case.

Thanks in advance for the help and consideration.