Need to know the logic for determining the interval between Y axis labels

[mathewrg]

Hi all,

I'm using Dundas chart for Windows control to plot charts, which are
already plotted using Excel. The problem is that the label intervals
for the Y axis given by Excel is different from what Dundas plots.
Need to know, the algorithm excel uses to determine the interval btwn
labels.

Thanks in advance,
Mathew

 

[Jon Peltier]

Microsoft describes in a Knowledge Base article how Excel determines minimum
and maximum spacing in terms of tick mark spacing, but I have never seen
anything that indicates how Excel determines this spacing. It seems to
depend on physical size of the chart, as well as size and content of the
axis labels.

- Jon