I'm trying to create a sub to clean-up the centering of Chart Title and Horizontal Axis Title on all charts in a sheet. The following code works for the Chart Titles:
I have not been able to find a similar approach that works for the Horizontal Axis Titles, which I'd like centered below the plot area.Please Login or Register to view this content.
Ideally I'd also like to be able to set the top border of the Chart Title to line up exactly with the top border of the entire chart.
Any help would be greatly appreciated.
Bookmarks