| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
copying charts into new sheets, data is pulled from old sheet
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
copying charts into new sheets, data is pulled from old sheet
instead of copying just the data, use the Move or Copy Sheet option under
Edit and copy the whole sheet. -- mam "kstevens" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Linear Mode
