M
Mark Stephens
Been trying to figure out how to do this for hours now I have run out of ideas.
I have managed to select the labels using the following code:
' add the chart
Set myChtObj = ActiveSheet.ChartObjects.Add(Left:=300, Width:=800, Top:=75 Height:=400)
With myChtObj.Chart
.Axes(xlCategory).TickLabelPosition = xlTickLabelPositionLow
.Axes(xlCategory).TickLabels.Select
End With
My usual way to find out how to do stuff like this is to record a macro then look at the code but the macro is not picking it up at all.
I checked the VBA help and it helpfully gives the syntax as follows:
TickLabels.Alignment Property (Excel)
Returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.
Syntax
expression.Alignment
expression A variable that represents a TickLabels object.
See Also
Concepts
TickLabels Object
TickLabels Object Members
Only problem is (not so helpfully!) it does not work!!!
It may be that this is a bug in the pprograme, which would be a shame as I really want my chart a certain way and to build it with code, if anyone hasany knowledge of how to do it or get round it or even knows for sure it isimpossible I would be very grateful.
Kind regards, Mark
I have managed to select the labels using the following code:
' add the chart
Set myChtObj = ActiveSheet.ChartObjects.Add(Left:=300, Width:=800, Top:=75 Height:=400)
With myChtObj.Chart
.Axes(xlCategory).TickLabelPosition = xlTickLabelPositionLow
.Axes(xlCategory).TickLabels.Select
End With
My usual way to find out how to do stuff like this is to record a macro then look at the code but the macro is not picking it up at all.
I checked the VBA help and it helpfully gives the syntax as follows:
TickLabels.Alignment Property (Excel)
Returns or sets a Long value that represents the alignment for the specified phonetic text or tick label.
Syntax
expression.Alignment
expression A variable that represents a TickLabels object.
See Also
Concepts
TickLabels Object
TickLabels Object Members
Only problem is (not so helpfully!) it does not work!!!
It may be that this is a bug in the pprograme, which would be a shame as I really want my chart a certain way and to build it with code, if anyone hasany knowledge of how to do it or get round it or even knows for sure it isimpossible I would be very grateful.
Kind regards, Mark