replace title

[Guest]

I have 15 excel files, except the basic numerical data, they almost identical
(they are created from same template file by changing data set).
Each file has 5 sheets and within each sheet, there are at lest 3 charts
(total 20 in each file).

Each chary has its own title.
The first part of title is ID that is the unique for each excel file (all
chart have same first part).

When I creat new file with new ID I currectly change all title of charts
manully.
Is there any easy way to change text of chart title, when ALL THE CHART have
SAME changing. Like replace command in tool bar.

 

[Tushar Mehta]

You would have to write your own macro to change the titles of all the
charts. However, it might be easier to link the title to a worksheet
cell. Then, change the contents of that cell and the chart title will
automatically change. To link a title to a cell see
Dynamic Chart Title
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_chart_title/index.html
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions