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 Where:=xlLocationAsObject, Name:=x
End With
i want to know how to write code so that I can place the charts where i want
to.
Bookmarks