Y axis scaling

[Lynn]

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?

 

[Jon Peltier]

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/Excel/Charts/axes.html#ArbAxis

- Jon