[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Need help with SharePoint Dashboard

Posted on 2013-12-20
3
Medium Priority
?
491 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

607 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