Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ?
I want to use the second axis to plot the normalized value of the default horizontal axis. I am using Excel 2007.
[Back at home now, so have rewritten for Excel 2007]
You can have a "primary" and "secondary" axis in some chart types (line, column and bar at least; maybe others) - they are in pairs so you can't have a secondary x-axis without a secondary y-axis, but you can make the secondary y-axis identical to the primary version, and then hide it, so it has no effect on the graph.
Can be something like the below image, should give you an idea of what I'm meaning:
A 3d column chart will probably do what you need:
You can set the front columns to be your normalized value and the rear columns to be your other values. In excel 2007 this is the last one on the right under
Let me know if this doesn't fit your needs.