Font Size in Chart Title

[Bill]

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

[Andy Pope]

Hi,

The syntax is correct. The Null would suggest that the charttitle
contains multiple font attributes. Have you formatted part of the title
in a different size?

If so you will need to check each character in the title, like this.

ActiveChart.ChartTitle.Characters(4,1).Font.Size

Cheers
Andy

Bill wrote:
> 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
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info