+ Reply to Thread
Results 1 to 2 of 2

Copy Chart and Data Down With Relative References

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    USA
    MS-Off Ver
    2019 16.0.13205.200000 64-bit
    Posts
    61

    Question Copy Chart and Data Down With Relative References

    Guys, I have an issue like this: I got a line of data, and a chart generated from it. I need to create multiple copies of this chart, but with different data (same structure, different numbers).
    The most straightforward way I can think of is to simply copy it all (data + chart) down, and then replace the numbers. BUT the problem is (of course) that charts only have a hard-coded absolute referencing. Is there a work-around for this behavior (=for making it relative when copying)?

    Please have a look at the file attached. I copied the original section with data and graph down several times, and as you can see it copies just fine, but the problem is that all the graphs that I copied are linked to data in row 1. But what I NEED/WANT to do is for instance data on second graph to be linked to row 16 when copying, data on third graph linked to row 31, etc. Is there ANY kind of a workaround to do this?

    I know some of you might probably suggest to make a copy of the sheet, but the problem is that I need to generate 200+ (yes, two hundred!) charts and having 200+ sheets (please do try to imagine 200 tabs) and going through them, switching through them seems like total hell (e.g. no good way to name them and actually be able to read the names, etc.). So IF there is really no better way to make copying-down work, well... I'll do the sheet-copying thing of course

    But guys, seriously, ANY help would be so, so appreciated!!!
    Attached Files Attached Files
    Last edited by splendidus; 07-05-2013 at 10:49 AM.
    Office 2019 16.0.13205.200000 64-bit

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Copy Chart and Data Down With Relative References

    chart.copy.sample.xlsm

    How's this? It uses the Offset function & a listbox to change the displayed data....Once you get the principle of operation, it's easily expanded
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1