Let's say I have a chart in Sheet1. It uses my data in Sheet1!A1:A10. I want to create an identical chart in Sheet2, using the data in Sheet2. My data for Sheet2 is in Sheet2!A1:A10, the exact same row/column address as my first sheet. However, if I copy and paste my chart from Sheet1 into Sheet2, the new chart still refers to the information in Sheet1. Is there anyway to make the data series in charts have relative sheet addresses and not fixed addresses? If there isn't an Excel option, could I do it with some type of Visual Basic Loop? I.E. The loop looks at my charts in various worksheets, replaces old worksheet destination with the name of the worksheet in which it currently resides? I don't know much (anything) about visual basic so I'm grasping in the dark here. Any help or directions would be helpful. Thanks, NukedWhale