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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyKg-r5NCrQukOzzM1JOowmm0mRKRo3lOtF89EM9RRIm973FOfCJoICGj6AXqvNs-v7Xgwv9lfOcoLayR_mJ8PddEfpy4pqjz_v4n3kEt0R4NFa4LumRgrGP2zcwCH5q5nuNIuvaU8P7bJ/s320/ScreenShot001.gif)
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