Excel Chart - Macro to globally change multiple chart titles?

[parodytx]

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")? All the charts are in a single worksheet page.

The update 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.

 

[Trevor G]

Welcome to the Forum,

Have you tried using a Cell Value for the Chart Titles that way all update as soon as you change the value.

Select your Chart Title then on the formula Bar press the equal sign and then select the cell.