Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace worksheet reference in multiple graphs
Hi,
I have a workbook containing approx 60 worksheets (15 stock categories x 4 worksheets). The 4 worksheets for each category are the same (replicated 15 times). One of the 4 worksheets contains a set of graphs (that graph data from the other 3 worksheets) that I have replicated for each category. Whilst I have been able to update the forumlae (worksheet references only- cells references remain the same) in the other 3 worksheets for all 15 categories using find/replace, this doesn't seem to work for graphs. All the cell references should be the same, it's just the worksheet references that need changing to reflect the respective category. Is there a way I can change the worksheet references in all the graphs to reflect the related category of stock without going in to each graph for each category of stock? Any help gratefully received...! K |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace worksheet reference in multiple graphs
This little utility should be able to help:
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "kippers" wrote in message ... Hi, I have a workbook containing approx 60 worksheets (15 stock categories x 4 worksheets). The 4 worksheets for each category are the same (replicated 15 times). One of the 4 worksheets contains a set of graphs (that graph data from the other 3 worksheets) that I have replicated for each category. Whilst I have been able to update the forumlae (worksheet references only- cells references remain the same) in the other 3 worksheets for all 15 categories using find/replace, this doesn't seem to work for graphs. All the cell references should be the same, it's just the worksheet references that need changing to reflect the respective category. Is there a way I can change the worksheet references in all the graphs to reflect the related category of stock without going in to each graph for each category of stock? Any help gratefully received...! K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit-Replace worksheet reference nightmare | Excel Discussion (Misc queries) | |||
Graphs reference data in old worksheet | Excel Discussion (Misc queries) | |||
Graphs reference data in old worksheet | Excel Discussion (Misc queries) | |||
find and replace cell reference to a new worksheet | Excel Worksheet Functions | |||
graphs from multiple worksheet : query | Charts and Charting in Excel |