Excel 2007 charting of x-axis label

[azz]

hello, all,

I'm new to this forum and hope to get your kind advise. I am trying to label my x-axis under the major tick instead of between tick. I attached the data, desired chart and what I can get.
Can you kindly give me some hint? Appreciate it.

[Andy Pope]

Not so easy in xl2007 as the combination of column and xy-scatter want to force the primary axis to be categorical even when the series on it is numeric.

But you can still work around it as xl2007 allows for the displaying of 2 axis on the same edge.

So the column chart is as normal
The xy-scatter series on the secondary axis allows for an axis with tickmarks to align with the edge of the columns.

[azz]

got it, Thank you!