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

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