I have an excel file that contains more than 200 charts.
Now I want to replace some text in all these charts' title, title of X-axis, title of Y-axis and text in legend.
Apparently it is a cumbersome task if I do it manually.
Is there automated way, like using VBA to do it?
Bookmarks