3
1
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
I am accepting Jon Peltier's answer because it definitely helped me (to remember that sometimes to do things in graphs in Excel, you have to do them from scratch...e.g. completely fake axes and labels in this case), and because I would rather give my accept to someone else. :) *Please see my answer for the full solution, though!* – A.M. – 2013-08-17T16:22:11.487