| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
???Replicate a sheet but chart still link to original sheet
I have a chart with named range in Sheet1.
When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is still linking to Sheet1. How can I make the source data link to sheet2 automatically. As I have to replicate sheet1 into 10 different sheets, the automation will help a lot. Would appreciate advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
???Replicate a sheet but chart still link to original sheet
Jon Peltier has instructions and a sample workbook with code that
changes the series formulas: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html Jaylin wrote: I have a chart with named range in Sheet1. When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is still linking to Sheet1. How can I make the source data link to sheet2 automatically. As I have to replicate sheet1 into 10 different sheets, the automation will help a lot. Would appreciate advice -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
| Link Sheet to sheet | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Can't save chart as object in current sheet | Charts and Charting in Excel | |||
Linear Mode
