Y axis weak?

[Guest]

Greetings everyone,
I have a nice line chart & chart data table. The Y axis minimum is manually
set to zero, i do not want to show negative values since it is not possible
for the data to get below zero. The problem is, when I get some zero values,
the data markers impinge on the Xaxis labels. I would like to retain the data
markers and put some space between the zero data points and the X axis labels
without having any extra tick marks and labels below zero on the Y axis.
TIA for your advice

 

[Jon Peltier]

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/
_______

 

[Guest]

Thanks Jon,
much appreciated