Thread: finding and replacing text in charts

hi,

i have a series of 40 worksheets in a workbook.
Each worksheet contains a type of graph (bar chart) or table.

The titles of each graph and table are exactly the same on every worksheet.

I would like to replace the "2008" in all the titles on each worksheet without out having to manully got to each one individually and clicking on the chart and re-typing.

I tried selecting all sheets but this doesnt work.
I created a macro but I still can't populate it to all sheets by selecting all sheets.

Hope you can help

Cheers