nikki333
05-30-2018, 01:55 PM
Hi Folks
So I'm trying to make consistently formated charts, with the chart title and axis title exactly at the same position relative to the chart frame/borders
Been trying like so so far:
With oShape
.Height = 59
.Width = 720
.Top = .parent.top - 5
.Left = .parent.left - 5
End With
My thought was to align those objects with the chart border. So I thought the parent object could help, but I'm not sure if i got a syntax problem, or if there is another way to do it
any ideas?
Cheers
So I'm trying to make consistently formated charts, with the chart title and axis title exactly at the same position relative to the chart frame/borders
Been trying like so so far:
With oShape
.Height = 59
.Width = 720
.Top = .parent.top - 5
.Left = .parent.left - 5
End With
My thought was to align those objects with the chart border. So I thought the parent object could help, but I'm not sure if i got a syntax problem, or if there is another way to do it
any ideas?
Cheers