I need to chart a lot of small tables that I generate by copy and paste to
have different data depending on the data I paste it next to. It takes me a
long time to set up a chart for even one of these tables and I need to paste
like over 100 of them. I'd like to be able to copy the table I'm making (it
pulls data from other areas in the spreadsheet depending upon where I paste
it) along with a chart which changes as the associated table is pasted.

The pasted table works fine, but when I copy the chart, the data always
refers back to the original table. If I try and just make another chart by
highlighting the whole table and inserting a chart, I find I have to do all
sorts of changes to make the chart work.

How do I copy a chart so that the data it pulls from changes in a relational
way as does the copy/paste of Excel formulas?