HELP NEEDED! How do i make 2 x-axis?

[au2111di]

Hi,
I have a set of results and i want to display the results on the x-axis as 2 different units. Is this possible? So on the X-axis i want for example Osmotic pressure and then right under it Molar concentration. So for say 1 molar, the osmotic pressure is 2 bar, and then for 2 molar the osmotic pressure is ........ I know you can have 2 y-axis one on either side of the graph but as i said, im looking for 2 scales!
Help please!

 

[Andrew Poulsom]

You can have a secondary x axis by using a combination Line/XY (Scatter) chart.

 

[Stormseed]

http://www.mrexcel.com/archive/Formatting/27980.html
http://www.mrexcel.com/archive2/44000/51147.htm

http://www.andypope.info/tips/tip008.htm

Hope these links prove a help to u

 

[venkat1926]

is this like charting temperature charts wth farenheit and centigrade scales

see this rul

http://www.tushar-mehta.com/excel/charts/0204-single graph dual axis.htm