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

Help Studio
, , ,
1

Hi members of the UiPath Forum,

I am stuck with a complex situation while automating Excel using Macro for Charts. may be this is not ideally a right platform to post this but any help is appreciated.

I have 18 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 ([url]Exporting Multiple Excel Charts To PowerPoint Using VBA - 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 a lot in advance for the help and consideration.

2

Hello @alpharobot!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff