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.

Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.

Sign up to join this community

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.

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.

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)

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

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

You are watching: Excel chart with two X-axes (horizontal), possible?. Info created by GBee English Center selection and synthesis along with other related topics.