I got a macro that toggles the legend on several pie charts 'on' and 'off'.
The trouble is that the original font of the legend is NOT retained after the legend has been turned on again (after having been turned off), i.e. the default font takes over.
How can I make sure that the original font of the legend (say 'Verdana') is retained on these turning on/turning off action?
Help is much appreciated.
I attached a sample file for your convenience.
Thank you very much in advance for your professional help.