copying charts into new sheets, data is pulled from old sheet

K

kstevens

i make a sheet with a load of data and some graphs,
then i want to copy the whole thing into a new sheet to process some similar
but different data,
all the cell references translate cleanly, and refer to the new sheet
however, the graphs reflec tthe previous sheets ranges and data.

how can i copy the graphs so they refer to cells on the new sheet?

btw i know excel pretty well, and i could go through and drag new data on,
but i would like about 30 graphs per sheet, so its tedious.
thanks
 
M

mickie

instead of copying just the data, use the Move or Copy Sheet option under
Edit and copy the whole sheet.
 

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

copy chart between multiple sheets in workbook 4
Graph links to copied sheet 1
pasting chart getting source data from new location 2
Custom error bars bug -- copy pasting chart does not update refere 5
Linking a copied chart to new data in Excel 2007 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Dynamic column chart - copying from Sheet to Sheet. 1
How do you chart data from multiple sheets within a workbook? 3

Top