Chart Placement

D

Dr.Schwartz

I have added a new chart (chart.add) in my code, but how can I place the
charts upper left corner at a certain cell - say C3? If I cant use a cell as
a reference how can I then place my chart? Note that I dont want to move the
chart, but place the chart right as it gets created.

Thanks
The Doctor
 
T

Tod

You can use the Top and Left properties of the cell and
the chart to line them up together.

'After the chart is created
With ActiveSheet.ChartObjects("Chart 1")
.Activate
.Top = Range("C3").Top
.Left = Range("C3").Left
End With

tod
 
Top