Results 1 to 3 of 3

Copy/Paste Chart to Sheet2, but Data is Still referenced from Sheet1. How do I update it?

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2016
    Location
    Chicago, IL
    MS-Off Ver
    2013
    Posts
    2

    Copy/Paste Chart to Sheet2, but Data is Still referenced from Sheet1. How do I update it?

    I have two almost identical worksheets. Sheet 1 & Sheet 2.
    I want to make a chart for each of them.
    I want to keep Chart 1 on Sheet 1. And I want to keep Chart 2 on Sheet 2.
    The charts are exactly the same, but very tedious.
    I just finished Chart 1 (on Sheet1), and want to copy it over to Sheet2, and just dynamically update all of the data on the 2nd chart, to reflect Sheet 2.

    Does someone more savvy than I know how to achieve this magnificent feat?

    Much appreciated!
    `````````````````````````````````````````
    Reworded:
    I have Data+Chart on Sheet1.
    If I copy everything to Sheet2, how do easily I make the new chart on Sheet2 reference the data on Sheet2 (instead of Sheet1)?
    Thanks!
    Last edited by Melissa60515; 09-27-2016 at 09:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy/Paste Data from Sheet1 to Sheet2
    By h.noor in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-11-2015, 11:39 PM
  2. Macro to copy the data from sheet1 and to paste it in sheet2 with conditions.
    By Thinker8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2014, 09:55 AM
  3. [SOLVED] Code to copy data from sheet1 to sheet2 the first time, and then update after that
    By Excelfail in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2014, 06:45 PM
  4. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  5. [SOLVED] Copy Range of data from sheet1 and sheet2 paste it in sheet3
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 05:55 AM
  6. Copy Range of data from sheet1 and sheet2 paste it in sheet3
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 05:47 AM
  7. [SOLVED] Copy data from column A and B Sheet1 and paste into Sheet2
    By rabra in forum Excel General
    Replies: 2
    Last Post: 02-03-2013, 11:39 AM

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