| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linking a copied chart to new data in Excel 2007
When I copy a sheet with data and a chart of that data to a new sheet, the
new chart still references the original data. Is there any way on Excel 2007 that I can copy a sheet with data and a chart of that data to a new sheet so that the new chart references the new data, allowing me to change the new data so that the new chart also changes, whilst the original chart stays the same? This would save me having to recreate the same chart for different sets of data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Odd Excel 2007 behavior: copied chart linked to source sheet | Charts and Charting in Excel | |||
| 2007 Excel/Powerpoint - Chart size when linking | Excel Discussion (Misc queries) | |||
| Insert copied row - Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot chart loses data connection when copied to new workbook | Charts and Charting in Excel | |||
| In copied worksheet, embedded chart uses data fm orig - change? | Charts and Charting in Excel | |||
Threaded Mode
