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

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

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
ps.com...
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