Putting a second axis on an Excel Graph 1

[brellis1]

I have a graph that plots Force vs Distance. Force on Y scale, Distance on X scale. However, I would also like to put the english units on the top and right of the scale. Is there a way to do this in Excel. In the end I hope it will look like this below.
Distance (English)-[Top axis]
Force(metric)-[Left Axis] Graph Force (English)-[Right Axis]
Distance (metric)-[Bottom Axis]

 

[tsurikov]

Hi,

Well, I'm not sure if it's possible to do dual X *and* Y axes in Excel, but it's definitely possible to add a second Y axis. Say you have force (N) vs distance (m). Add another data column for force (lb). Now add another data series to your plot, using the distance (m) as X and force (lb) as Y. Double-click on this data series, choose "Axes", and select "Secondary axis"; click OK. The secondary axis now appears. Now, double-click the secondary axis. Convert the primary axis Min and Max values from N to lb, and enter those values EXACTLY into the secondary axis Min and Max; click OK. You now have two plots that should overlap exactly - looking like one.

Not the most elegant or complete solution, but it gets you partway there...!

Cheers!

 

[brellis1]

Thanks, that worked like a charm