Excel 2003 - VBA - Charting

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
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
 
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,

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - VBA - Charting 2
Excel 2003 - VBA - Charting 1
Reversing Dates Sequence along X axis in a chart 3
Dynamic charts with named range Windows 8.1 3
Excel trendline formula: capital E 4
problem with an Excel chart 1
Stacked Bar Chart 1
How can I add a 3rd axis to my chart? 3

Back
Top