Chart Title and Axis Title positioning

[nikki333]

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

[p45cal]

There appear to be restrictions, differing by chart type, on just where and what size you can have your titles. In addition, this seems to vary by Excel version.
I strongly suspect that you may end up adding shapes with text to replace existing titles which will give you full control.
Set up a file with your chart in with a bit of code that you've tried so far and attach it to your next message here. It'll answer a lot of questions.

[nikki333]

Thank you for your response. I guess I'd be able to figure it out using boxes, but that's a bit of a cumbersome solution, so I'm giving up that idea for the moment. Cheers