LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the size of a chart title box? Gr8fulDavid Charts and Charting in Excel 3 April 2nd 23 06:46 PM
Size of plot area expands when Chart Title is deleted - why? Chuck M Charts and Charting in Excel 2 June 22nd 07 01:05 PM
Title Block in Excel Chart - Size problem Stuart Saich Charts and Charting in Excel 1 October 25th 05 11:44 AM
Has anyone had problems setting the font size for a title through VBA? Viv2004 Charts and Charting in Excel 4 August 28th 05 12:23 PM
font size of row and title heads Dave B Excel Discussion (Misc queries) 3 April 12th 05 02:50 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"