I wonder whether it is possible to re-format the chart title of ALL charts so that they match the chart title of the currently selected chart with respect to ...
... font size of the chart title
....font type (Arial, Calibri etc.)
....font property such as underline, bold or italic
I have attached a sample file for your convenience. In this file I have re-formatted the chart title of chart 1 to ...
.... Arial font
....font size of 12
....font property bold.
Is it possible by means of a macro to select chart 1 (the one with the re-formatted chart title) and apply above properties automatically to the chart titles of the other charts.
Help is much appreciated. Thank you very much in advance.