Hi Chris,
Yes. The y-axis labels can be "right aligned". But you need to specify what should the labels aligned to.
Suppose you want the labels to right aligned to the right edge of the chart. You need to determine what is the from the label starting point on the axis to the right edge. (You may just take the distance of the right axis to the right edge, minus a margin such as 8.)
Suppose that distance is 50. The code is then (in VB/VBScript):
Set t = c.yAxis2().setLabelStyle("arial.ttf", 8)
Call t.setSize(50, 0)
Call t.setAlignment(cd.Right)
Hope this can help.
Regards
Peter Kwan |