Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find replace format | Excel Discussion (Misc queries) | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Search and replace | Excel Worksheet Functions | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
replace absolute references | Excel Worksheet Functions |