|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 9th 06, 08:56 AM
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******* 
|
| Ads |
|
#2
October 9th 06, 03:14 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sum up columns in different sheet with error check | zeyneddine | Excel Discussion (Misc queries) | 13 | July 10th 06 01:21 PM |
| Dynamic column chart - copying from Sheet to Sheet. | Marko Pinteric | Charts and Charting in Excel | 1 | April 10th 06 12:57 PM |
| Link Sheet to sheet | hennessey | Excel Discussion (Misc queries) | 1 | February 27th 06 07:30 PM |
| variable in a link where the variable is the name of the sheet | darrelly | Excel Worksheet Functions | 1 | October 7th 05 08:24 AM |
| Can't save chart as object in current sheet | Ann Scharpf | Charts and Charting in Excel | 1 | December 3rd 04 11:24 PM |
Linear Mode
