Solved

Need help with SharePoint Dashboard

Posted on 2013-12-20
3
453 Views
Last Modified: 2013-12-27
Hello,

I have some data like this:

Desc.       Status      Number    Color
                                Value      Indicator
-----------------------------------------------
Goal A    Done          4            Green
Goal B    On Track    3            Blue
Goal C     Late           2            Red
Goal D    New           1            Blue
Goal E     Deferred    0            Black

This data can be in an Excel spreadsheet and I like to display it on a SharePoint 2010 page as a dashboard.

Can you provide from some steps on how to set this up in SharePoint 2010?

Thanks,

Paul
0
Comment
Question by:PBIT
  • 2
3 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39733850
Hi,
which edition of SharePoint 2010 do you have?
If it is Enterprise then you can setup and use Excel Services and Excel Web Access to display a chart/pivot table from a published Excel file.

Alternative could be to store the data in a SharePoint list and using jQuery / SPServices, some magic Javascript and some Javascript charting framework to display the results using Content Editor Webpart.

HTH
Rainer
0
 

Author Closing Comment

by:PBIT
ID: 39740216
I have the Enterprise Edition of SharePoint 2010.  I will use an Excel file.
0
 

Author Comment

by:PBIT
ID: 39742893
I have a follow up:

Can I display some cells in a worksheet as a dashboard?  I like to use the conditioned formatting on cells.  See attachment.
Dashboard.xlsx
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now