below code changes the font size and font name on all charts of the active worksheet.
I also would like to expand this macro so that also ...
... all the data labels of the charts' data series as well as
... the x-axis (Category Axis) also get changed to Verdana and Font Size 10
Help is much appreciated. Thank you very much in advance.
Dim Charts As ChartObject
For Each Charts In ActiveSheet.ChartObjects
ActiveChart.ChartTitle.Font.Name = "Verdana"
ActiveChart.ChartTitle.Font.Size = 9