Keep X-axis numbers horizontal?

D

Don Wiss

Somtimes the chart rotates the x-axis numbers 90 degrees. It does this even
when there is enough room to have them horizontal. Is there a way I can
force them to be horizontal?

Don <donwiss at panix.com>.
 
G

Greg Wilson

Try:

ActiveSheet.ChartObjects(1).Chart. _
Axes(xlCategory).TickLabels.Orientation = 0

Regards,
Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Area chart with X-Y chart characteristics? 1
Horizontal Axis Options Changing 6
Chart disappearing when source data hidden? 1
Restoring Horizontal Axis Labels 1
Custom Angle and Alignment with VBA 1
Move x axis to the top of a 3D horizontal bar chart 1
Charts Having X Axis Scaled Using Calendar Weeks 4
x-axis dates 3

Top