Thread: replace title
View Single Post
  #1   Report Post  
Terry
 
Posts: n/a
Default replace title

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.