NukedWhale Posted April 14, 2008 Share Posted April 14, 2008 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 Link to comment Share on other sites More sharing options...
spacesurfer Posted April 15, 2008 Share Posted April 15, 2008 I would also like to know how to do this. Link to comment Share on other sites More sharing options...
NukedWhale Posted April 15, 2008 Author Share Posted April 15, 2008 I found that if you copy a worksheet that contains a chart, the new worksheet's chart will use the new worksheet for the series formulas.I created my desired chart format in one worksheet using a real dataset and then copied that worksheet and pasted the new source data over my old data.I also found some information that could possibly be used for a VBA solution.http://peltiertech.com/Excel/Charts/ChgSrsFmla.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now