ReversePlotOrder problem with Category labels.

[sts023]

Hi Guys....

I have a simple line chart (Excel 2010) plotting a debt, charting dates on the X (horizontal) axis, and values on the Y (vertical) axis.

As it happens, the values currently run chronologically from values of approx -5,000 to approx -2,000.

Plotting this, the chart's line rises left to right, heading up to zero which is at the top of the Y axis.

The Boss reasons that as the debt is reducing, the line should be coming down to zero, which should be on the bottom of the Y axis.

So I tried recording a macro (the chart is created using VBA) ticking the "Values in Reverse Order" on the Axis Options in the Format Axis options.

I then included the VBA code

ActiveChart.Axis(xlValue).ReversePlotOrder = True

in the creation code, and apart from one problem, the graph is exactly what The Boss wants.

The problem (which I can't work out how to fix, and which also occurs when executed manually), is that the date labels are now at the top of the Y axis, immediately under the Chart Title.

I can't find a way to bring the category axis labels back to the bottom of the chart.

Can anyone suggest a way?

Thanks in advance....