David -
Double click on the Y axis. Set the minimum to one major unit below zero
(so you have to uncheck auto for the major tick spacing too), and ensure
that the X axis crosses at zero. Then on the number format tab, define a
custom format that shows nothing for a negative number. A number format
has four parts, separated by semicolons, where the parts refer to
display of positive, negative, zero, and text values. Leave nothing for
the format of negative numbers, and you'll get no negative labels. For
example:
0.00;;0.00;@
0;;0;@
General;;General;@
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
> Greetings everyone,
> I have a nice line chart & chart data table. The Y axis minimum is manually
[quoted text clipped - 4 lines]
> without having any extra tick marks and labels below zero on the Y axis.
> TIA for your advice
David - 17 Oct 2005 20:45 GMT
Thanks Jon,
much appreciated
--
David