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

  • Thread starter Thread starter mathewrg
  • Start date Start date
M

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

showing start of each month as tick mark & label on X-Y chart 1
How do I put words as the Y axis values? 0
Interval Between Labels problem 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Horizontal Axis Options Changing 6
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Pivot Chart - X-axis labels when adding data 0

Back
Top