Macro to Place chart in specified Range

[shiva_reshs]

Hi All,

Charts.Add
    ActiveChart.SetSourceData Source:=Sheets("OM Error Trend").Range("K7")
    ActiveChart.Location Where:=""

Every time I execute the code it creates the chart but in new sheet. I want to place it in same sheet in L1 and below range.

FYI, My first code "Sheets("OM Error Trend").Range("K7")" is located near pivot so it picks the graph from there.

Help needed.

Regards
Shiva