I am trying to set up a sharepoint document library where excel files will be uploaded by users. Based on this data, i need to construct a couple of graphs for each collected excel file and insert all those graphs in one powerpoint file.
From what i've been reading lately, we can do this one of the following ways :
You export to powerpoint from power view. However, this implies the development of Power views which is not necessarily my business need Ref : https://support.office.com/en-us/article/export-a-report-from-power-view-in-sharepoint-to-powerpoint-508a5d85-6619-43ef-b3ea-6a4094b573ef
Export to Excel, automate chart creation (VBA ?) and link prepared PowerPoint to those charts. However, having tried posting excel files on a SharePoint with VBA code, the solution turned out to be very unstable (correct IE version to be used, SharePoint Library page should be open)
Some Over The Shelf existing solution. (Is there any free solutions?)
Which brings me here for feedback on the easiest way to do this. Also, I am neither admin on my PC or on SharePoint Server.