Is there a way to dynamically create the range?

[roger892]

I'm trying to create a macro that will chart based on any selected range.
Instead of setting the range statically as in the example below, is there a way to have the range be what is selected by the user? Dynamic rather than static.

ActiveChart.SetSourceData Source:=Sheets("Sheet15").Range("A14"), PlotBy _:=xlRows


Thanks