Excel - multi-axis graph 1

[baddy]

I am trying to make a graph in Excel with different axis on both the left and right side; I am trying to compare trend lines between two sets of data. I have been told this is possible, but can't seem to figure it out. Is there any way to do this?

 

[RamziSaab]

Draw both series with one axis first.

Then once the graph is drawn right click on the line (opr column) you want to be on the second axis and pick format data series. goto the axia tab and click on secondary axis.


Hope it helps

 

[baddy]

Perfect, thank you.