Extract Group of Excel chart to PPT Slide and put a header for that group

Are there 6 charts in each excel tab with a header or do you have all of these charts in one sheet?

If you can it would be worth uploading a dummy workbook with the structure of your data nd maybe a ppt slide with the output.

Thanks for your reply.

All the charts are in one excel, is it possible to do that way? Or we need to split that in different sheets?

Headers are static, we can even add that in Macro.

unable to add the attachment (may be due to the new user restrictions)