Hello,
I have an embedded chart on a worksheet. I want to know the font size in
the title so I can adjust it. I tried the following:

ActiveSheet.ChartObjects("newchart").Activate
textsize = ActiveChart.ChartTitle.Characters.Font.Size

But I get a null value for textsize. How can I do this?

Thanks,

Bill