y-axis tick mark labels overlap x-axis

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
 
J

Jon Peltier

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
 

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

Top