Thread: 3 Y-axis (on one side) graph - cannot make in office 2007

Hello,

I am undertaking my final year report at university, where i am required to plot Young's Modulus, Ultimate Tensile Strength and Elongation at Break on the same graph (all as the y-axis) with material type as the x-axis.

These three groups of data need to be displayed on the same graph, one set of data is 1,000,000,000's (GPa) another in 1,000,000's (MPa) the other in % (elongation).

the three variable's are plotted on three y-axis (all on the left).

I know how to plot a graph with a secondary y axis (one y on the left one on the right) but not when it comes to a third axis.

any help anyone can give me would be much appreciated...and you will get a mention as a thank you / contributor on my work if you wish!!

Many thanks in advance,

Phil H. Loughborough University

Hi thankyou for your reply, but i have previously tried that web page and found the links appearing with the message "Error 404 - Page not found!"


I took it that it meant the link was dead - i have visited that link through several sites, none unfortunately gave me any luck - i would ideally like to create a graph simialar to the one shown at the top of the main link (http://peltiertech.com/Excel/Charts/TertiaryAxis.html) where you have a tertiary y axis - but no instructions are to be found as links are dead.

thank you all the same, Phil