Sounds like you are using Copy&Paste. The chart will still be pointing to
the original data.

Open the workbooks; use Window | Arrange to view them side by side
Holding down CTRL, drag the tab of the source worksheet to the target
workbook
Now you have an exact replica of the source worksheet and the charts use the
data on the replica


Alternatively: click on each data series in the chart, look in the formula
bar and you will see something like
=SERIES(,,[Book1]Sheet1!$A$1:$A$7,1); Edit this to remove [Book1] and change
Sheet! to the name of the current worksheet. Now the chart is linked to its
current worksheet in the current workbook

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"kippers" wrote in message
...
Hi,

I currently have a number of graphs (10-12) that I need to replicate (for
different data obviously) across 14 worksheets (approx 140-150 graphs in
total). I am copying the relevant worksheet into the different work books
and amending the source range, however, I have noticed that the data
values
do not automatically update (even when the rest of the graph does). So I
can
have a bar chart showing one figure and the data label saying another.

Does anyone know of updating the data values automatically i.e. to reflect
the data point that the data value is representing? If not, I'll have to
go
through each graph individually which probably won't be feasible.

Any help much appreciated!

R