vba chart query

[weakvba]

Hi there.

i have data in sheet 2 and sheet3. i want to build a macro that produces chart from data in sheet1 and 2 and puts then in sheet1 starting in cell a2 and second sheet2 chart in a30. i have earlier tried building a macro that produces chart in sheet2 copies charts cuts and pastes in sheets 1. but is i run macro again it would produce another chart in sheet 2 and i will get excel error. can anyone please help me with a macro that produces chart in sheet2 and sheets 3 and pastes thats in sheet1, if data is changes in sheet2 and sheet3 chart changes in sheet1 .

many thanks for help in advance