VBA to change a charts name

First foray into VBA Created charts and I'm losing my mind. I have a macro that creates a chart based on the data that is selected in a listbox userform. I wanted to name the chart based on a string variable that I set through the user form but I can't even get name it anything right now. I've attached the first half of the macro code, the last line is where I am erroring.

Please Login or Register  to view this content.

I want to say ActiveChart.Name = "" & chartit & "" in a perfect world because that would give each chart a unique name based on its data set. Help?

Thank you that took care of it. I am also wondering how can I tell the chart where to land/move once it is created. I want to have the upper left corner of the first chart start in A1 and have subsequent charts start below. I was planning on using a loop to place a value in a cell below each chart as it was created and use that to reference the spot for the next chart to start at but my charts are landing in the middle of the page. Any ideas what I can do? Same code but I am attaching all of it now, w/ edits I've made. Everything works fine, just need to know what to do to get the chart to refernce a specific cell upon creation.

Please Login or Register  to view this content.

Thanks!