Hi,

I'm trying to get dual x-axis for multiple sets of data (same x values).

the data would be of the form:

wavelength energy transmission
300 =[Simple formula using wavelength] 100
310 =[Simple formula using wavelength] 85
..
..
..

essentially I'm after a chart that uses columns A & B as the x data and plots C against it as the y-data. However, as A is increasing, B is decreasing so this seems to make things more difficult!

Does anyone have any thoughts on how to do this in excel?

Dear god I need professional) help!

Cheers
David

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com