After seeing somme comments about how LineChart handles (or not) missing values, I just downloaded and tested the template file from Sourceforge.
Here is the result... Looks OK to me.
There are however two problematic cases with LineChart.
1) the case of an isolated value : you need 2 values to draw a line, so individual poin will not be displayed if the GapStyle parameter is different than 1 or 2
2) when all values are identical and the scale (Min and Max) is not defined ... where should the resulting horizonal line be drawn ? In order to see it, specify Min and Max.
If you have found more cases, please send me a screenshot at : sparklines.excel - at- gmail.com