Font Size in Chart Title

B

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unreadable text when viewing organization chart in Web version of Visio 365 0
Filtered view of Visio Chart 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Need help modifying code 0
Doughnut Chart linked with the slicer in the pivot table 0
How can the font and size of (all) citation numbers be altered? 1
Word Template and Normal Style 1
Excel 2010. How to copy chart format to all charts in sheet 2

Top