Copy chart with reference table

A

Arun

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?
 
J

Jon Peltier

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
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Export BPMN Visio Chart to Excel 0
Pie Chart and Table Query 2
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2
Copy chart with associated table 0

Top