John Report post Posted December 21, 2007 (edited) 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 Share this post Link to post Share on other sites
Pallav Report post Posted December 21, 2007 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. Share this post Link to post Share on other sites
John Report post Posted December 24, 2007 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 Share this post Link to post Share on other sites
