1
Is it possible to create in Excel a dual-horizontal axis plot, showing on the top horizontal axis the Energy and on the bottom the Wavelength (both on x-axis)? The energy is related to wavelength using this equation: Energy (eV)= 1240/Wavelength (nm). Simply creating "secondary axis" does not work. Below are some examples that were created using different software. Many thanks in advance!
The required Energy/Wavelength dual axis plot. Here is another view of the dual x-axis plot.