In other words, I want Excel to anchor the tick marks at ** 0**.

I am trying to get an axis that goes from **-35 to 35**, but with the ticks on multiples of 10:

- 30, 20, 10,
**0**, -10, -20, -30

I have set set a "fixed" (custom) major unit to 10, and with my data the max and min would be -40 and 40 automatically, so I have also set "fixed" values for the axis ends (-35 for minimum and 35 for maximum).

...but then the tick marks are at:

- 35, 25, 15, 5, -5, -15, -25, 35

How can I force the tick marks to be grounded at 0? (This should be the default!)

Edit: This picture pretty much explains the problem.

...and here are some data you can copy and paste into Excel to graph if you can solve this. ;)

x

0

0

0

y

30

-20

-30

– A.M. Aug 17 '13 at 16:22Please see my answer for the full solution, though!