Y axis scaling

I would like to set my value axis minimum to be 14.3 but I
would like the scale to read 14.5, 15, 15.5 etc. (ie the X
axis will cross at 14.3 but my first tick would be
displayed at 14.5) Is this possible?

Lynn -

All the tick marks have to be evenly spaced. You have a couple options.
You can set the minimum to 14.0 and the spacing to 0.5, then have the
axis cross at 14.3; this leaves 0.3 of the Y axis below the X axis.

Or you could try the Arbitrary Axis Scale example on my web site:
http://www.geocities.com/jonpeltier...es.html#ArbAxis

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Lynn wrote:
> I would like to set my value axis minimum to be 14.3 but I
> would like the scale to read 14.5, 15, 15.5 etc. (ie the X
> axis will cross at 14.3 but my first tick would be
> displayed at 14.5) Is this possible?