| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to copy sheet with charts without link to original data
I have a worksheet with ten charts on it. I need to copy the worksheet with
all its data and related charts to new sheets or files so I have a page for every day, with different data entered every day. But when I copy the worksheet with embedded charts and paste it into a new file, the charts pull their source data from the original worksheet, not the new one. The source data Value box is written as such, ='03-09-10'!$D$12 any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| ???Replicate a sheet but chart still link to original sheet | Charts and Charting in Excel | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Links and Linking in Excel | |||
Threaded Mode
