Change Y axis so it does not start at Zero 1

[amosohi]

I am creating a simple horizontal bar chart but I want to be able to control where the Y-axis starts. If I specify 50 for the Y-axis starting position, data with a value of greater than 50 should appear on the right and anything less than 50 should appear on the left. This is very similar to negative values which appear on the left. Any help would be greatly appreciated.

 

[Andie]

I'm not sure this will entirely answer your question, but here's how to atleast change the y axis (version 7).

When you create the chart (chart expert), go to the tab "axis" and unselect the "auto range" for the data axis. You can then specify what range you want for the y-axis.

For further options, go to "Custom Chart | Chart editor" from the first tab. In the chart editor, select any of the values along the y-axis. Right click and select scale range. Here again you can specifiy the range you would like. You can also select whether or not to show out-of-range values.

I hope this helps a little!

 

[Guest_imported]

I had already tried the min axis solution and as I was using version 8, I did not have the chart editor, to display out of range values. However, is it possible to see the out of range values as a bar going backwards, similar to a minus value?