I have a data series with a max value of +0.788 and a minimum value of -0.823. I currently have these plotted on a second Y axis of a chart with data in a completely different rang on the primary Y axis. The X axis just carries the data series name and the Y axis are ploteed against this.

Currently XL is plotting an axis with a minimum value of -1 to a maximum of +1, with mid point of zero and linear points in between. For most purposes this would be fine however I require the range to run from -0.1 to +0.1 with zero midpoint (non sequentially E.g.

-0.1, -0.2, -0.3, -0.4, -0.5, -0.6, -0.7, -0.8, -0.9, 0, +0.9, +0.8, +0.7, +0.6, +0.5, +0.4, +0.3, +0.2, +0.1

and obviously the relevant data plotted against these points on the axis.

Have researched custom axis on the web and all rely on a logical (numerative seqence) anyone any ideas?