y axis scale on both sides of graph

[daftwood]

Hi,

Does anyone know of an easy way of getting the y axis scale on both sides of the graph for ease of reading?

Thanks for any help

Martyn

 

[Oaktree]

You could create two series, both referencing the same data.

Then, right click on a data point of one of the series, go to format data series, Axes, and choose "Plot series on Secondary Axes".

You'll have two series names in your legend though, so you'll want to turn your legend off.

 

[daftwood]

Thanks Oaktree, a bit of lateral thinking always helps!

Martyn