Forum

Notifications
Clear all

Centering a chart title again

3 Posts
3 Users
0 Reactions
90 Views
(@johnjacobson)
Posts: 1
New Member
Topic starter
 

Aloha,

A chart title is centered, until... the chart title is manually moved, which breaks the centered property.  How does one reset the centered property on the chart title?  I can't find anything in properties or methods...

Mahalo for any feedback,

John Jacobson

 
Posted : 10/11/2018 5:00 pm
(@mynda)
Posts: 4762
Member Admin
 

Hi John,

I usually just do it by eye, but you could try removing the title and then adding back in again. Copy your title text first so you can paste it back in.

Mynda

 
Posted : 10/11/2018 7:15 pm
(@debaser)
Posts: 838
Member Moderator
 

To do it in code, you can just use:

 

ActiveChart.SetElement msoElementChartTitleCenteredOverlay

 

The same approach should also work manually.

 
Posted : 13/11/2018 11:44 am
Share: