PC Review

Thread Tools Rate Thread

Copy chart with associated table

Posts: n/a
      13th Dec 2009
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?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Loading Table with Associated Foreign Table David Microsoft Access 5 16th Mar 2010 03:48 AM
drag point on line chart to change data in associated cell cmax Microsoft Excel Charting 5 3rd Nov 2009 08:43 AM
Hide the tab with the data associated with a chart =?Utf-8?B?SXJlbmUgT0w=?= Microsoft Excel Charting 1 1st Aug 2007 07:21 PM
Showing Pivot Table total on Associated Pivot Chart =?Utf-8?B?S2VuWQ==?= Microsoft Excel Misc 2 18th May 2007 02:41 PM
Copy associated records Derek Microsoft Access Forms 4 29th Jan 2004 08:29 PM




All times are GMT +1. The time now is 11:45 PM.