Solved

Need help with SharePoint Dashboard

Posted on 2013-12-20
3
450 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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. …
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

707 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

18 Experts available now in Live!

Get 1:1 Help Now