Copy chart, reverence to source data

Hi

I'm new here and not so familiar to VBA, so I need help.

What I'm trying to do is copy both a table and a chart multiple times on the same sheet.

The problem I get is that all the charts point to the same source data. I assume this have to be done with a macro, which I i have no clue how to do.

Can someone please help me ?

Thanks a lot!

chart.xlsm

Hi Meathead,

Welcome to the forums.

You can also do this without a macro. Once you follow this technique, you can then cut/paste the table and chart back to the original worksheet. Here is a step-by-step and video tutorial:
How-to Copy Charts and Change References to New Worksheet

Let me know if it helps.

Steve=True