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

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

-----Original Message-----
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
.