Here is the code generated when I record in Excel 2003

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
With ActiveChart.Axes(xlCategory)
.TickLabelSpacing = 1
.TickMarkSpacing = 1
.ReversePlotOrder = True
.AxisBetweenCategories = False
End With

maybe this will help
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JoeG" wrote:

I must say , working with the component is pretty much a nightmare and
waste of time, as the structure is convoluted, different than Excel, and
there's no macro recorder to aid in figuring out the bizarre calls.

That off my chest

I can't seem to nail down or find anywhere, the command to reverse the
axis plotting, which is available from the wysiwyg under the Axis editor, as
order - Show values in reverse order.

The excel version reverseplotorder , is not available.