C Craig Brandt Jan 8, 2009 #1 Is there a way to get the "Y" labels to show up on the right end of the chart, rather then the left? Craig
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 Jan 8, 2009 #2 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
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 Jan 9, 2009 #4 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
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
