Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there any way to create a dashboard, and use KPI from a shared doc lib that contain excel sheets ?

thanks

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted

I'd recommend migrating your use of Excel Spreadsheets to store the KPIs onto using Custom Lists within the SharePoint platform. There, you will be able to easily produce KPI reporting based on this SharePoint List.

This method is dependent on the requirements of both your reporting and your acquisition of the data used for the KPI, and also the version of SharePoint which you are using, all of which you have not stated, so a realistic and fulfilling solution cannot yet be recommended.

share|improve this answer
    
how to link the sharepoint list, with a excel sheet column ? –  Iyad May 26 '10 at 13:32
    
Once you have created a SharePoint list from a template or with custom columns, you can link to Excel by using the option in the "Actions" menu in the toolbar of the List. –  James Love May 26 '10 at 14:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.