Thankyou John

I will have a look

"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