Macro code error

I am trying to record a macro that will take seleted data from a spread sheet and graph it but I am getting the following error. ' - 2147024809( 80070057 ) '

The macro does produce a graph along with this highlighted line of code in the "debuger"

ActiveSheet.ChartObjects("Chart 1").Activate

My question is why is this happening? And why doesnt the macro record all of the changes I make the to graph, such as; changing the size of the graph and moving the legend. Any changes I make to the graph will not be included in my macro?

Any help would be appreciated.

Hi Marshall, welcome to the forum.

Please take a moment to review the forum rules - link in my signature below - and then amend your thread title to something descriptive of your problem.

Thank you.