Hi! This is my very first post here, so hello everyone!

I am writing a marco that creates a chart everytime it is run, however, I want the previous chart to be deleted before the new one is created. Right now, each chart is just layered over one another. I tried recording a macro to see the code for chart deletion, but it references a chart name, such as Chart58. Because each time the macro is run a new chart name would be assigned, I can't use this kind of name. I have tried deleting rows as well. That works when I do it, but not when I run the code. Any ideas!
Thanks!!!!