Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
see also… – Ale Oct 30 '13 at 11:54
up vote 16 down vote accepted

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


  • 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:
    Excel 2007 Ribbon; options to show secondary chart axis

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


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)
Example chart showing secondary x-axis

share|improve this answer
it is also explained in the official support docs:… – John_West May 13 at 8:40

A 3d column chart will probably do what you need:
alt text

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 3d-Column.

Let me know if this doesn't fit your needs.

share|improve this answer
A 3D column chart may accommodate the data, but not in a way that makes it at all intelligible. This would most likely be best as an XY Scatter chart, with two series: one using regular X values, the other using normalized X values, and both using the same Y values. After adding the secondary horizontal axis, delete the secondary vertical axis. – Jon Peltier Nov 14 '13 at 14:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .