Put the date into a cell. Next time you replace them all in the charts,
inset a textbox that's linked to this cell. The easy way to do this is to
select the chart, click in the formula bar, type =, then click on the cell.
This textbox will be linked to the cell and update accordingly.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Pat" wrote in message
...
Is there way to "Find & Replace" some text (current date) in a multitude
of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need to
have the date changed on a weekly basis. Currently I am copying the new
date
and pasting into each one, but figured someone would have a better
solution.

Any ideas are greatly appreciated.

Thank you!