Chart Title Name Declaration

Question

I format the chart, and all of these instructions work fine, except for the last one. What is the correct form?

ActiveChart.ChartTitle.Select ActiveChart.ChartTitle.Text = "History of IMS Transaction 'SPTVMS02'" ActiveChart.ChartTitle.Font.Size = 20 ActiveChart.ChartTitle.Font.Bold = False ActiveChart.ChartTitle.Font.Color = RGB(110, 10, 155) ***ActiveChart.ChartTitle.Font.Name = 'Calibri'*** 

Answer 1

You should have double quotes around the font name instead of single quotes:

  ActiveChart.ChartTitle.Font.Name = "Calibri"