ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keep X-axis numbers horizontal? (https://www.excelbanter.com/excel-programming/298610-keep-x-axis-numbers-horizontal.html)

Don Wiss

Keep X-axis numbers horizontal?
 
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.

Greg Wilson[_4_]

Keep X-axis numbers horizontal?
 
Try:

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

Regards,
Greg

-----Original Message-----
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.
.



All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com