Chart references and worksheet copying -- HELP!

P

Paul R

I have an Excel worksheet with a chart on it. If I make a new copy of the
sheet, the chart is copied as well, but it refers to data on the ORIGINAL
sheet, not the copy.

I could manually change the chart data range, but it there any way that this
could be done at the time the worksheet is copied? What if I had several
charts? This could get time consuming.

I basically want to copy an entire worksheet, often with several charts, and
have the charts on the new worksheet refer to data on the new worksheet. Is
this possible?
 

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
Move Chart with Text 0
Creating Network Diagram using a Chart SW integration 0
Chart references when copying worksheets -- HELP! 0
Embed the same Excel multiple times 0
Chart references when copying worksheets 3
Create a chart from a table in word thats dynamic 0
Copying embedded charts 1

Top