We use msline.swf to display financial funds performances.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
We would like to have global rule to be able to determine in any case Y axis scale (min value, max value, number of division lines) by making sure:
Number of division lines is fixed = 5, which is easy,
Min and max values correspond mostly to the min and max values of points to be displayed, which is also very easy,
But also that one of the division lines does correspond to the 0 value, which is not easy!
This means that requires some specific algorithm to calculate min and max values. Is there anyone who has got an idea of a rule or algorithm to apply to determine best min and max value, depending on number of division lines and make sure that one of this division line is on 0 value. It looks like it is a usual requirement when we display fund performance graphs.