line graph macro

[weakvba]

Hi ,

i am trying to build line chart in sheet 2 copying chart pasting in sheet 1 cell a2 and paste it, but when i run macro it gives error. can anyone help me on this please where i can build line graph in sheet 2 copy and cut that chart and paste in sheet 1. also if data is updated in sheet2 , sheet1 graph updates automatically

thanks

 

[VoG]

Essentially a duplicate of http://www.mrexcel.com/forum/showthread.php?t=569821

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).