Excel 2003 - VBA - Charting

[Craig Brandt]

Is there a way to get the "Y" labels to show up on the right end of the
chart, rather then the left?

Craig

 

[Andy Pope]

Hi,

The Crosses property set to xlMaximim should do it,

'---------
With ActiveChart.Axes(xlCategory)
.Crosses = xlMaximum
.TickLabelSpacing = 1
.TickMarkSpacing = 1
.AxisBetweenCategories = True
.ReversePlotOrder = False
End With
'---------

Cheers
Andy

 

[Craig Brandt]

Andy:

I have no idea why, but it worked.

Thanks,
Craig

 

[Andy Pope]

Hi,

To explain, the code is the equivalent of manually, in xl2003 or older,
double clicking X axis and on the Scale tab checking the option,
Value (Y) axis crosses at maximum category.

Cheers
Andy