I am writing a macro that generates charts that are to be placed in a new
worksheet. I want to be able to place the chart exactly in the worksheets but
I dont know how to code it. I cannot use the macro recorder because it is too
inexact and it does not produce a good code. My code is:

Charts.Add
With ActiveChart
.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Standard"
.ChartType = xlColumnClustered
.SetSourceData Source etc..........

.Location Whe=xlLocationAsObject, Name:=x
End With

i want to know how to write code so that I can place the charts where i want
to.