+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste Chart and Data // Want Relative References, Not Absolute

  1. #1
    Registered User
    Join Date
    04-24-2008
    Posts
    85

    Copy and Paste Chart and Data // Want Relative References, Not Absolute

    Hello,
    I am making a report that has lots of graphs, a lot of my data is coming in from other sources so that I only have to change one cell and my data tables will refresh.

    I'd like to copy and paste my tables and graphs (as I have to do this about 50 times) and not have to change the source data of my graph each time... right now when I grab the 30 rows that contain my data and my graph and paste them, the graphs are still referencing the old data...

    Is there a way to change the SERIES reference of the graph from absolute to relative?

    If this is unclear let me know, thanks in advance for your help.

    Adam

  2. #2
    Registered User
    Join Date
    01-14-2014
    Location
    Boston
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Copy and Paste Chart and Data // Want Relative References, Not Absolute

    Hi, just curious if this was solved? Was wondering the same thing. Thank you

+ 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