Case Study: Using Sparklines Charts and Graphs in a SharePoint List
Earlier this month, Christophe Humbert led a live online workshop, SharePoint Charts and Graphs: Sparklines» , on how to create miniature inline charts and graphs with Sparklines and jQuery. At the end of each live session we do, we always ask people to stay in touch to tell us what they do with the solutions they learn in the workshop.
Ken Osterkamp did a nice job of utilizing the resources. I’ll let him describe his usage in his SharePoint production environment:
“This list was developed by a national nonprofit that advocates on health care issues. It tracks votes on a single bill, HR 3590, in the United States Senate. There is a row for each Senator grouped by region. The columns track their votes, beginning with the cloture vote to begin debate on the bill, continuing through various amendments and ending with the vote on final passage. The list also feeds a dashboard, where the goal is to get 50% or higher support for the votes.” — Ken Osterkamp
Not only did Ken build a KPI dashboard, he also used SparkLines to keep track of time based events for each row of information.
This is pretty exciting stuff from our point of view. Ken was able to jump into his SharePoint production environment and implement the solutions in a very short time. It makes me and Christophe really happy when we get examples of real world use of the workshop solutions.
Congratulations, Ken. Glad it all worked out. — Mark
SharePoint has very limited OOTB charting options. Fortunately charting tools are plentiful on the Web, and can be integrated with SharePoint. This workshop will review some of the available options, featuring in particular Sparklines (inline charts) solutions.
With the announcement that SharePoint 2010 will include Sparkline for creating charts and graphs, the solutions provided in this workshop will give you a two to three year jump start, incorporating Sparklines into current WSS and MOSS sites.
You won’t have to purchase any third party web parts to implement these solutions. Everything will be available out of the box or available for free as part of the resources for the workshop.
on
We are using them for our ‘Projects and Tasks’. The only thing I would like to see is the colors ‘change when the ‘past due’ date has passed. Sound like a ‘workshop’ that will be useful ;)
I would like to view the presentation “Case Study: Using Sparklines Charts and Graphs in a Sharepoint List”, but I cannot find how to view it. Can you help?
James Moore
James – I’m not sure what you are referring to… you are looking at the case study in this article. If you are talking about how he learned to do it, that’s part of a live online workshop that we’ll be running again in the near future. — Mark
Do you have any workshops coming up on creating dashboards for recurring events in a SharePoint calendar list? I cannot get the built-in KPI functionality to work with a calendar list or recurring tasks
Thank you