B
baconcow
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
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