Rotating Axis Labels in VB

[hamhains]

Hi,

I'm making a program which automatically creates a graph from an external file. This all works great, and I'm now onto the formatting of the graph. The only things I can't figure out is how to get the macro to rotate axis text. (For instance if I have a label each day, I want these values rotated). When I record a macro and rotate the text, no code shows up in the recorded section.

Any thoughts?

Thanks!

[Andy Pope]

Please Login or Register  to view this content.

[hamhains]

Amazing, thanks! No idea why that code wont show when I try to record a macro.

[Andy Pope]

In xl2007 chart/shape recorder code was almost no existent.
They (MS) improved it for xl2010 but is still not complete, as you discovered.