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.
speed92uAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
The data has to be a pretty clean Excel 2007 workbook for best results.

Go into Shared Services and set the location of your workbook to be a trusted location.

Enable the Reporting features etc.

Create a Reporting Site

Create a KPI list inside the reporting site.

Create a new item in the KPI list that links to spreadsheet

Select the spreadsheet and select the parameters that display the KPIs

Back in the site where you want to display the results, add a KPI web part. Point this to the KPI list you created,

In broad brush terms, job done!
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
speed92uAuthor Commented:
I need to design a dashboard something like the uploaded image. Can anyone suggest where I can download such graphs/charts or whatever. Please help me. Thanks.
Dashboard.jpg
0
Jamie McAllister MVPSharePoint ConsultantCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.