double x axis

[andrewz]

In Excel 2007 I want to create a second X axis with a different scale like this
http://www.mathworks.de/matlabcentra...ifferent-scale

I'm working with ACD interaction routing and trying to show the relationship of Interaction Scores (Y axis) in relation to Time in Queue. For calls, the scale (X) is about 0-200 seconds. For emails, the scale (X) is about 0 to 60 hours (216,000 seconds).

[Andy Pope]

In order to create a secondary x axis the chart must have at least 2 data series.
Move 1 of the series to the secondary axis. This will apply a secondary Y axis.
You then need to add the secondary x axis.

Right click chart
Chart Options
Axes
Enable secondary X axis