Quote:
Question is that why sheet 1 values are adding instead of just updating with new values rather shifting to new columns.
Because the code for chart generate an event that launch another piece of code (unlisted) that result in what you say.
Since you play with events, one need the WorkBook (Excel file) to track down what append exactly. I am getting paid for this kind of stuff.
Resolution of this is beyond the scope of this forum.