Excel chart with two X-axes (horizontal), possible?

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.

Solution 1:

[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.

Instructions:

• Create your basic chart with the required series.

• Right-click the series line for each series that should use the secondary pair of axis, select Format Data Series. And inside the Series Options tab choose Secondary Axis.

• Right-click the chart itself and click Select Data.., select on of the series to use the secondary axis and define the Horizontal (Category) Labels.

• From the ribbon make the Secondary Axis visible, like so:
  

• Tweak the chart as needed. You may find it useful to use the "more options" option from the image above on the secondary y-axis to ensure it matches your requirements, you can also hide the secondary y-axis, if needed, from the same place.

Result

Can be something like the below image, should give you an idea of what I'm meaning:
(This is a simple contrived graph I've just thrown together, but should get the point across)