Hi.

I want to copy a chart to every sheet I have, but when I do this the chart just take the data from the sheet where I copied it from. What I want it to do is to update the data it so it takes it from the sheet where I paste it in.

All the different data is in the same cells in each sheet. I hope somebody can help me. It would save me for a lot of time!

I have very many sheets so I can't update the chart so it takes the right data in every sheet manually.

Please help or this would take forever