Sparkline - incorrect scale with target line?

[John]

I am generating a sparkline with a target line. The target line represents a limit that the values are not supposed to breach. It's fine if any of the values "cross" the target line, but if not - as below - the scale for the chart is not automatically chosen to show the target line...

 

 

 

I think I can workaround by checking for the largest value and setting yAxisMaxValue...

 

 

 

Bug?

 

 

 

Thanks

 

 

 

John

Edited December 21, 2007 by Guest

[Pallav]

The limits for a chart are calculated based on its values, as the values are predominant figures of the chart.

 

 

 

If you've a trendline which is bigger than any value, you can just set [chart yAxisMaxValue=value of trendline].

 

 

 

In this case, the trendline always shows up, irrespective of any value. And, if the value is greater than the y-axis max value, the axis limit is automatically adjusted to a new value.

[John]

OK - I'll do that.

 

 

 

Just thought that a trendline ought to be taken into account when auto-setting the axis values.

 

 

 

As you say I can easily loop through the data and check myself...

 

 

 

Thanks

 

 

 

John