macro table and chart

[lezawang]

Hi
I started recording a macro. I created an empty table and then a chart (which is empty as well). The I stopped recording the macro.

Now I went to second sheet and I ran the macro, the table and the chart was created. So far so good. But when I updated the first sheet table, the chart of course will be changed (from empty to something) but the chart in the second sheet got updated with same data!! the table in the sheet2 remains empty (that is what suppose to). So why the second chart got updated?

Thank you.