On 2009.03.12, at 08:23 , Irv Bromberg wrote:
Irv adds: OK, I've added an "Automatically Scale" checkbox option to the "Setup" page. It uses the list of axis scale settings that appear on the "Scale" worksheet.
Irv adds further: This way of handling the y-axis scale is crude, but effective, yet certainly far from general purpose. Can anybody point me in the direction of an algorithm or set of rules for general purpose selection of "nice" axis scales, where the axis span (or 1/2 span in this case) is divisible by the major interval, which in turn is divisible by a suitably small minor interval?
Anyhow, try this with my spreadsheet and automatic scaling switched on: For any leap cycle, choose a 20-year step size. You'll see wild monthly oscillations. (Some curves may be nearly smooth if they happen to be close to a multiple of the lunar cycle away from the middle year.) Change the step size to 19 years and update the chart, then the curves will all be quite smooth.
-- Irv Bromberg, Toronto, Canada
