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!