Chart with dynamic name

Hello all,

Can a macro make a new chart in a new sheet with a dynamic name?

e.g. The value of a cell D2 in sheet "parameters".

I tried :

    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xlXYScatterSmooth
    ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="=parameters!$D$2"

But this named the new chart (sheet) actually : =parameters!$D$2


Thanks,