y-axis tick mark labels overlap x-axis

  • Thread starter Thread starter Charlie157
  • Start date Start date
C

Charlie157

Hi,

New here, looks like a great place. Wondered if anyone could help me.
In Excel 2002 I am plotting a xy scatterplot with an x-axis that run
from -25 to +25 (major unit = 5, minor unit = 1) and a y-axis that run
from -10 to +12 (major unit =2, minor unit = 1). Crucially, the 'Valu
(X) axis Crosses at:' is -10 on the y-axis.

Annoyingly, the -10 tick mark label (where the axes meet) untidily sit
on top of the x-axis (try it and see what I mean!).

Is there anyway to remove the -10 tick mark label without losing th
other tick marks on that axis, that go up in steps of -8, -6, -4 etc.?

Thank you for any help that you can give with this!

All the best
 
Double click on the Y axis, and apply this custom number format to the
axis tick labels:

[=-10]"";General

If the format isn't General, replace General by whatever the format is.

- Jon
 
Back
Top