I am trying to put footer in several charts. I have written the footer:
.LeftFooter = ""
.CenterFooter = "&""Times New Roman,Regular""&8&T &D. " & ActiveWorkbook.FullName & "" & Application.ActiveSheet.Name
.RightFooter = ""
However when I select the chart and go to Tools/Macro the only options shown are Record New Macro and Visual Basic Editor.
Can anyone help?