Naming and Titling a Chart with VBA

[IowaIrishman]

To those who might help me:

I am new to programming macros and am learing painfully by experience. I have set up a macro to extract data into a chart, but found that in order to use the macro successfully I had to re-name the chart such that Excel's natural sequential naming process does not interfere. I have read up on some of the forums on how to do this, and have attempted several times, however it trips the debugger every time. I have also tried to apply a title to the chart, and was summarily foiled as well. I am uncertain what I am doing incorrectly, and I would be greatly appreciative of any responses and aid you might offer!

Please Login or Register  to view this content.

[Andy Pope]

You need to set the name of the parent object.
You need to add a title before you can set the text.

Please Login or Register  to view this content.

[IowaIrishman]

Thanks Andy! I'm learning slowly by degrees. I appreciate your time helping me out!