Unfortunately these articles are less helpful than they appear on first reading.
They describe how the min and max are determined with respect to the major unit.
Unfortunately they keep secret the method used to calculate the major unit itself.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John Mansfield wrote:

Nick,

These Microsoft KnowledgeBase articles should help:

(1) How Chart Axis Limits are Determined:

http://support.microsoft.com/?scid=h...ticle%3D101939

(2) XL2000:How Chart Axis Limits are Determined:

http://support.microsoft.com/?kbid=214075

----
Regards,
John Mansfield
http://www.pdbook.com




"Nick Turner" wrote:


Hi All

I am creating a standard bar chart and I need to know what the maximum value
on the y axis will be. Also, I need to know the size of increments and how
many there will be.

I was hoping somebody might know the formula that Excel uses when creating
the chart to define these values on the y-axis.

Any help would be appreciated

Thankyou