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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Copy Data From Chart to Chart

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

    Copy Data from Chart to Chart

    Guest, Jun 9, 2004, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    400
    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:
    277
    Guest
    Jun 10, 2004
  4. Guest

    Copy Data From Chart to Chart

    Guest, Jun 10, 2004, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    356
    Jon Peltier
    Jun 12, 2004
  5. Guest

    How do you link chart source data when you copy the chart?

    Guest, Dec 7, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    683
    Jon Peltier
    Dec 8, 2006
  6. Guest

    Hide the tab with the data associated with a chart

    Guest, Aug 1, 2007, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    260
    Gklass
    Aug 1, 2007
  7. cmax
    Replies:
    5
    Views:
    2,229
    Misange
    Nov 3, 2009
  8. Astelix

    copy chart formatting and chart templates in Excel 2007

    Astelix, Mar 1, 2010, in forum: Microsoft Excel Charting
    Replies:
    4
    Views:
    5,002
    Jon Peltier
    Mar 4, 2010
Loading...