This project has moved. For the latest updates, please go here.

Setting GapWidth, BaseUnit and TickLabels.Orientation for ColumnStacked charts

Jan 9, 2015 at 10:17 AM
I need to be able to accomplish the following VBA operations on a ColumnStacked chart (the XAxis values are end of month dates, so it needs to be set up as months, otherwise the bars correspond to a single day and are very thin).
ActiveChart.Axes(xlCategory).BaseUnit = xlMonths
ActiveChart.ChartGroups(1).GapWidth = 10
ActiveChart.Axes(xlCategory).TickLabels.Orientation = xlVertical
Is it supported? I couldn't find any way to do it, but I may have overlooked some properties.
Thanks.