Vertical Axis With Negative Value

J

Jan

I have a negative value in the axis that I don't wish to display. Also the
horizontal line displays at 0 and I want it to be after the negative value.
Any ideas?

4
2
0______________________________________
-2

Want it to display as

4
2
0
_______________________________________
 
J

Jon Peltier

A custom number format will hide the negative number:

0;0;;@

Move the horizontal axis down by double clicking on the vertical axis, and
choosing an appropriate value for Category Axis Crosses At. You could enter
the minimum of the Y axis, or to ensure it is always at the bottom, enter a
very negative number, like -10000000.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Display Negative Time Values on Y-Axis 0
Positioning x axis at bottom of chart with negative values 5
2-axis problem with horizontal crossing 1
2007 move axis label & add zero line 1
Data labels along below x axis when y axis has negative values 1
Excel 2007: X-axis labeling 1
change chart primary horizontal axis label or name 1

Top