Custom Angle and Alignment with VBA
Pouring through the different ticklabel objects, I finally found the proper
one:
ch111.Axes(xlCategory, xlPrimary).TickLabels.Orientation = 60
(you need to use +60 if you want an angle of -60, don't know why... and -60
for an angle of +60)
Hope this helps somebody who needs it.
"baconcow" wrote:
In Excel, I am using VBA to create charts. However, I have not figured out
how to use them quite as in-depth. One of the things I cannot recreate is the
following function:
When I click on an axis and go to "Format Axis" and then click
on"Alignment", I can then change the "Text layout".
I want VBA to change it to
Vertical alignment "Middle Centered" (default),
Text direction "Horizontal" (default)
Custom angle "60 degrees" (not default)
Whenever I record a macro and change the custom angle, it never shows up in
the code. Is there a way to do this with VBA? Thanks
|