Copy and Paste Chart Troubles

[cdegar01]

Hello all, I have a question regarding charts in excel. I have about 16 charts per page in a worksheet. I regularly add new pages, each with unique data sets. My problem is that when I copy the charts and paste below to a new page, the charts still reference the same data above. I would appreciate it if anyone could tell me how to copy and paste a chart so that it will reference the data relative to where it is pasted. Thanks for your help!

 

[Juan Pablo González]

I think there's no "easy" way of doing that... I'm pretty sure that VBA is needed to make it easier.

See if this utility by Jon Peltier helps:

http://www.geocities.com/jonpeltier/Excel/Charts/ChgSrsFmla.html