Resetting Excel chart’s title or axis-label alignment back to centered

Topic

New Reply

Aloha folks,

Is it possible to re-set the alignment of an Excel chart’s title or axis label back to centered? These items are centered initially — but once one manually resizes or moves such an item, it is no longer centered. If this is possible, what is the syntax for re-centering a chart title?

Mahalo for your help,

John Jacobson

Reply | Quote

Replies

For example:

Code:

    ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenter

Reply | Quote