Excel 2003 - VBA - Charting

C

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
 
A

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
 
A

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
 
Top