I have to create a large report each month with continuously updated data. In the report are over 16 Excel 2003 charts all with all chart titles containing a string "As of 31 Xxx 2011" where "Xxx" is the standard 3 letter month abbreviation.

I have been able to find code that will update each chart's data individually, where you click on the chart, run the macro and the series updates etc. But for titles it doesn't work and I could just edit the individual title for the same effect as easily.

Is it possible for write a macro that will select ALL the charts on the active sheet, find the substring in each title (such as "Mar") and replace it with a second substring (such as "Apr")?

The data could be hard coded each month in say cells A1 & B1 and the macro updates all the charts from these cells.

Thanks for any help you may provide.