Putting a chart at the last cell (with macros)

[hero85]

Hello,

I can create a chart with Macros, however that chart always appears in the middle of the page.

I would like that chart to be moved down to the last cell. I have used the following code but it gave me an error.

Charts.Add
ActiveChart.ChartType = xlLastCell
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("C1:C105,H1:H105"), _

Thanks.