Font Size in Chart Title
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 |
Font Size in Chart Title
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 |
All times are GMT +1. The time now is 04:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com