Sparkline Horizontal Axis Does Not Display

[goss]

Hi all,

Using Excel 2013.

I created a sparkline group for 12 months QA data for 11 reps
I added markers for high, low and end points.
Now I'm trying to add a Horizontal Axis by calculating variances to a Target value of 98.0

The probel is that in some cases all scores are below 98, so the Horizontal Axis does not display.
Is there a way to get the Horizontal Axis to display in these cases without identifying a high point incorrectly?

thx
w

[goss]

Solved.

I looped through all columns in the data source and checked each against the target value
If the sum of the count of items lesser or greater was equal to the number of columns in the data source then I was able to figure out if I should set MinScaleType = 0 or MaxScaleType = 0

thx
w