Position chart

[David]

Hi Group,
Looked through several sources, but can not seem to find
the code to make a chart the upper left corner at "L2." I
know it exits, because I have done it before, but cn not
remmber the syntax.
Thanks

 

[David]

There is another way, where you designate the cell where
you want the upper left of the chart to be, but I can not
remeber the syntax. thanks David

 

[NickHK]

David,
<Object Browser>
Property TopLeftCell As Range
read-only
Member of Excel.ChartObject
</Object Browser>

Unless there's another way ??

NickHK

 

[NickHK]

David,
That's what this property shows, but as you see the object browser is saying
it is read-only.

Maybe:
Do Until MyChart.TopLeftCell.Column=MyRange.Column
MyChart.Left=MyChart.Left+1
Loop

NickHK

 

[Andy Pope]

Hi,

Try this,

ActiveChart.Parent.Left = Range("L2").Left
ActiveChart.Parent.Top = Range("L2").Top

Cheers
Andy

 

[David]

Thanks, this does exactly what I want it to do. The
syntax is differant than what I used before, so I think
there is another way to do it. But it works great.
Thanks, again.