I've been trying to create a sparkline that shows the missing months at zero, instead of connecting the line from, say Sept to Dec 2016 (as shown below). I know I should format the Special Values so that it shows at "Default Value", whoever for some reason it doesn't seem to work. I guess this must be a simple thing but I haven't been able to figure it out.
I could use the area graph which seems to do what I'm looking for:
but I need to use the Line graph for several other reasons.
What bothers me the most is that I managed to do it once. I have it done in a saved worksheet, but I can not replicate it anymore!!!. Even using the same data source and same fields I can not do it again It's driving me crazy!.