Copy chart with associated table

Discussion in 'Microsoft Excel Charting' started by Arun, Dec 13, 2009.

  1. Arun

    Arun Guest

    I have a table with a chart alongside that is neatly tied to it.

    I now want to duplicate this chart / table pair multiple times on the same
    sheet so I can change the table data and get unique charts. I select all the
    rows that contain the table / chart pairing then copy and paste them down
    below. I now have a new "table 2" and a new "chart 2"- however the new
    "chart 2" is still tied to the data on "table 1" and I am now forced to go
    into the new chart and change all the source references manually.

    Not a big deal except that each chart has 10 references and I want 10 charts
    - so there will be 90 manual changes and likely errors. Is there any way to
    make the copy charts with relative references?
     
    Arun, Dec 13, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Copy Data From Chart to Chart

    Guest, Jun 9, 2004, in forum: Microsoft Excel Charting
    Replies:
    0
    Views:
    174
    Guest
    Jun 9, 2004
  2. Guest

    Copy Data from Chart to Chart

    Guest, Jun 9, 2004, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    209
    Jon Peltier
    Jun 11, 2004
  3. Guest

    Copy Data From Chart to Chart

    Guest, Jun 10, 2004, in forum: Microsoft Excel Charting
    Replies:
    0
    Views:
    170
    Guest
    Jun 10, 2004
  4. Guest

    Hide the tab with the data associated with a chart

    Guest, Aug 1, 2007, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    179
    Gklass
    Aug 1, 2007
  5. cmax
    Replies:
    5
    Views:
    1,351
    Misange
    Nov 3, 2009
Loading...

Share This Page