| TJ's profileTJ's MusingsPhotosBlogLists |  Tools  Help |
|
|
February 14 Graphics in a SharePoint ListYesterday, I was trying come up with a method to present a better visual representation of task status and progress for a client on their SharePoint site. I ran across an article on “Creating a Dashboard (Bar Chart) in SharePoint” by Pam Davis. While I found her approach compelling, I thought it to be a quite involved process. Then, in the comments to her blog posting, I noticed an entry by Christophe Humbert who “claimed” to have a much simpler approach. This intrigued me as I had first heard that name just last week during Mark Miller’s online presentation on Dashboards to the New York SharePoint Users Group. Christophe’s approach uses calculated columns to write HTML and then exposes the graphics using a Java script embedded into a Content Editor Web Part that’s hidden at the bottom of the SharePoint list. In another blog, he explains how to use color coding in SharePoint lists and gives examples of using traffic lights, the default SharePoint KPI Indicators, font colors, and/or background colors. It seemed simple enough, so I gave it a shot using his default SharePoint KPI indicators. Very easy to use and it worked great, except my KPI Indicators did not sequence correctly and, in one case, did not even appear – the dreaded red X on the image. Exploring why this was occurring led me to a plethora of SharePoint KPI indicators that I didn’t even know existed Out of the Box (OOTB):
You can even use the KPI trend arrows:
You can find all the SharePoint “Out of the Box” graphics at C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\Template\IMAGES. If you read Christophe’s blog on Using Color Coding in SharePoint Lists, you’ll notice that he uses a formula to calculate the SharePoint default KPI Indicator indices of 0, 1 or 2 (not being familiar with the formula he used, I mistakenly thought he was calculating indices of 1, 2, 3 and that’s what I put into my initial formula which I had converted to an IF statement - that’s why my initial attempt failed leading me to my discovery of the variety of KPI Indicators above). After experimenting with his approach, my client’s pages now look like this:
Above chart’s Task Progress is computed by comparing %Complete with the %Time Completed.
Above chart’s Progress is computed as the %Complete.
For information on the Progress Bars shown above, see another of Christophe’s blogs. My thanks to both Pam Davis & Christophe Humbert for helping me help a client! Quote of the Day:
Technorati Tags: SharePoint,Dashboards  February 01 SharePoint OnlineRan across Vedant's Blog : Getting to know SharePoint Online this morning which has some excellent background material on Microsoft’s SharePoint Online which is part of Microsoft’s Business Productivity Online Suite (BPOS). If you’re interested in just general information on BPOS or, more specifically, SharePoint Online, I highly recommend this informative article. That’s it for today, time to get ready for the Super Bowl!
Quote of the Day: Technorati Tags: SharePoint,BPOS April 19 Good SharePoint Tips |
|
|
