|
 c.xAxis().addmark |
| Posted by Jamie on Jun-25-2011 02:28 |
|
| I am using VBA and creating bar charts. I would like to add two xAxis marks where the labels do not overlap. (see attached) I cannot use the set Alignment(cd.right) as it is too low on the chart and will interfere with the bars. Is there a way to specify where the label should be located, other than the top, bottom commands?
|
| Re: c.xAxis().addmark |
| Posted by Peter Kwan on Jun-25-2011 05:13 |
|
Hi Jamie,
You may move the mark using Box.setPos. For example, in VB/VBScript/VBA:
'Put the mark at a certain position
Set mark = c.xAxis().addMark(.........)
Call mark.setAlignment(........)
'Move the mark text by (x, y) pixel units
Call mark.setPos(x, y)
Hope this can help.
Regards
Peter Kwan |
|
Forum Home
Search
Message List
Post Message
(Jamie) 