In a previous post I showed how to create a Sparkline in a list view by using a ‘Hyperlink or Picture’ column. This previous example used the Google Chart API to render the Sparkline but this requires an active connection to the Internet. If you want to create something similar but an Internet connection is not available, why not use Excel Services and the REST API. Here’s what it can look like:
Here’s how you do it:
Step1 – Create a custom list, in my example I’ve called this ‘SparkLines’
Step 2 – Add a column to contain the numeric value you wish to plot. In my example I’ve called this ‘Value’
Step 3 – Add a column to host the Sparkline image. This needs to be created as a ‘Hyperlink or Picture’ column and ensure the display option for the column is set to ‘Format URL as: Picture’.
View original post 546 more words