Line Graph on 2 axis

[hibster]

Hi Board,

i'm looking at creating a graph on 2 axis showing the change in price on one axis and the % change on the other axis, with date across the bottom. Given that price and % change are the same, ie a rise will show the same % rise etc, i was hoping to see 1 line on the graph, and the axis's to scale themselves in order to match, instead i received 2 lines on the graph with differences due to the scaling of the axis. Is there a simple way to do this??

Kind Regards

mark

 

[Andrew Poulsom]

Can't you just adjust min and max of one of the axis scales so that they line up?

http://peltiertech.com/Excel/Charts/AlignXon2Ys.html