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