Copying Charts

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have created a worksheet with about 10 charts on it. I want to replicate it
over a further 11 worksheets (one for each month), but when I do the charts
always refer back to the original worksheet and I have to chabe each chart.

Is there a way around this?
 
Copy the sheet with the charts and data, then change the data on the copied
sheet.

- Jon
 
I have already copied the sheets, but then you have to go into each chart as
it still refers back to the original sheet by name. I was looking for a way
to make it automaticaly refer to the sheet it is on.
 
What version of Excel?
Is the data on the sheet that contains the embedded charts?

Close the file, make a copy and rename it. Open both files, then drag the
relevant sheets from the copy to the original file.

- 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

Copying embedded charts 1
Copying Named Ranges in Chart Series 1
How to create a bubble chart with more than 2 variables 0
Chart Location Impact On Links When Copying To New Workbook 1
Chart Relative To Worksheet When Copying- Excel 2007 1
How to chart months by financial year 0
how to copy sheet with charts without link to original data 6
Copy a group of Chart tabs 2

Back
Top