Thread: Formatting 2nd Axis

Hi,

I have some bar and line graphs with two Y axes. The problem is that the right (2nd) axis has automatically formatted so that the line lies neatly over the bars, except I want to change it so that the y-axis crosses the x-axis at 0 as the graph is otherwise misleading. I can format the first (lhs) axis to do what ever I want, but I can't format this axis.

Clicking on the RHS axis: Format Axis -scale tab - Category (X) axis crosses at: "0" is ticked but it still crosses at a different point (eg 0.05).

I have 7 different graphs which all have the same problem.

Is there any way I can change this?

Thanks

Thanks for you help. Andy, that website is exactly what I was after.

Thanks again!