Bar graph, two axes, one with negative values

[DLombard]

I have a bar graph with two value axes. Scale of the primary axis is 0 to 25; scale of the secondary is -1 to 8. The category axis crosses the primary y-axis at 0, but the secondary at -1 (with the result that the bars with a positive value seem to start in mid-air above the x-axis).

If I look at Format Axis, Scale, there is a tick in the box which says "Category Axis crosses at ...", and a value of zero in the field next to it. (This is the case for both y-axes.)

Any advice how to "shift", so to speak, the secondary y-axis to cross the x at y=0?

Thanks in advance!



(Is it possible to insert a screen dump of the graph here to illustrate what I'm talking about?)

 

[wsjackman]

do you need the -1 min value on youe secondary axis. iyu change the minimum to 0 it should look better. if you need it to show the negative, you will need change both the max and min values such that there is an identical ratio of positive to negative for both axis.

 

[DLombard]

Thanks very much -- it works if both axes have same negative to positive pro rata range.