speed92u
asked on
How to extract data from Excel Sheet and show it as Dashboard in Sharepoint Site
Hello everyone,
I need help with this. How to extract data from Excel Sheet and show it as Dashboard in Sharepoint Site. Please guide me how to do this and also can anyone suggest me sites for downloading any out-of-box dashboards or charts/graphs (becoz I have to display the data in form of Graphs/Charts).
And also one of my buddy told me as it is difficult to pull data from Excel Sheet and display in the form of Dashboards. Is it true? If it is possible, can you please write it. Otherwise any alternative methods to do it? Thanks and appreciate your response.
I need help with this. How to extract data from Excel Sheet and show it as Dashboard in Sharepoint Site. Please guide me how to do this and also can anyone suggest me sites for downloading any out-of-box dashboards or charts/graphs (becoz I have to display the data in form of Graphs/Charts).
And also one of my buddy told me as it is difficult to pull data from Excel Sheet and display in the form of Dashboards. Is it true? If it is possible, can you please write it. Otherwise any alternative methods to do it? Thanks and appreciate your response.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There's a really easy way to achieve this, total work around:
Create the graphs in Excel, and run a macro to export them as graphics.
Hyperlink to the graphics on your dashboard page in SharePoint.
If you can get Excel services to work you can also connect to the Charts in the workbook via excel services.
This is much simpler than trying to achieve this in SharePoint. SharePoint doesn't do the graphing itself in any easy way.
If you must pull in the data and create the graphs in SharePoint itself, you're looking at a third party product such as Dundas. License is about $2000.
Create the graphs in Excel, and run a macro to export them as graphics.
Hyperlink to the graphics on your dashboard page in SharePoint.
If you can get Excel services to work you can also connect to the Charts in the workbook via excel services.
This is much simpler than trying to achieve this in SharePoint. SharePoint doesn't do the graphing itself in any easy way.
If you must pull in the data and create the graphs in SharePoint itself, you're looking at a third party product such as Dundas. License is about $2000.
ASKER
Dashboard.jpg