Forum Discussion
mynona520
Jun 25, 2023Copper Contributor
Risk Matrix in Sharepoint
I'm totally new to Sharepoint. My task is to enter an excel file in Sharepoint. The Excel should collect data that I enter into a Sharepoint list (more precisely, this data is a risk overview, e.g. w...
Lalit Mohan
Jun 26, 2023Iron Contributor
Hi, mynona520
Yes, it is possible to create a solution where an Excel file collects data from a SharePoint list, generates a graph based on that data, and publishes it on SharePoint. It requires connecting Excel to SharePoint, designing the Excel template with formulas and charts, retrieving data from SharePoint, generating the graph, saving the file on SharePoint, and automating the update process if desired. Some technical expertise may be needed for this task.
Yes, it is possible to create a solution where an Excel file collects data from a SharePoint list, generates a graph based on that data, and publishes it on SharePoint. It requires connecting Excel to SharePoint, designing the Excel template with formulas and charts, retrieving data from SharePoint, generating the graph, saving the file on SharePoint, and automating the update process if desired. Some technical expertise may be needed for this task.