Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy chart with reference table
I have a pie chart neatly tied to a data table alongside. Now I want to copy
both the chart and table to a different area of the sheet so I can modify the new data table and have 2 different charts. My issue is that the chart will only allow absolute references, so when I copy both the chart and table together the new chart still is tied to the old table - so I have to go and change the source data ranges one by one. Any way that I can do this easily? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy chart with reference table
Copy the whole sheet. The copied chart links to the data on the copied
sheet. Now cut the range that includes the copied chart and its data, and paste it back onto the first sheet. Finally delete the copied sheet. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Arun wrote: I have a pie chart neatly tied to a data table alongside. Now I want to copy both the chart and table to a different area of the sheet so I can modify the new data table and have 2 different charts. My issue is that the chart will only allow absolute references, so when I copy both the chart and table together the new chart still is tied to the old table - so I have to go and change the source data ranges one by one. Any way that I can do this easily? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data from pivot table using relative reference | Excel Discussion (Misc queries) | |||
copy reference number | New Users to Excel | |||
Trying to set up a cross reference chart, best way to copy formulas? | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Column Reference Copy | Excel Worksheet Functions |