Chart Axis with a small negative

[FredMcStaire]

Howdy, I have a chart where the values on the x axis range from -6m to +280m. I would like the major units to be $50m starting from 0. I would also like a minimum value of -10m and a maximum value of +300m. Given that i've fixed the min and max values, How can I get the axis major unit labels to display the following : -10,0,50,100,150...
Thanks!
ps. using excel 2010

 

[pgc01]

Hi Fred

You cannot do it directly with the axis options.

The usual way to do it is to discard the default axis and create your own custom axis.

A custom X-axis is simply a horizontal line at Y=0 connecting values that you provide and to which you attach labels.

How I'd do it:

1 - get rid of the default X-Axis: in the X-Axis options set "Major tick mark type", "Minor tick mark type" and "Axis labels" all to None.

2 - Add a new scatter series, with Y=0 in all points and X values the ones that will appear on the axis

3 - Add labels to the points

 

[FredMcStaire]

Thank you for the original reply. And Imagine my reply when, 4 years later I had the same question and the top search result was the Q&A. so thank you twice!