I need to be able to draw a new graph as I change the parameters, but that
means that I would have to re-enter the source reference for the X and Y
values. In order to do that I concatenated a string that builds the address,
then I copy it and paste it to the chart's source references. I need to do
that with a macro. When I run the Excel macro utility to recreate all my
steps it inserts a reference that remains permanent. When I run the macro
again it does not paste the new reference but remains with the old one I
inserted previously.