Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Alter internal margins of chart title using VBA, Excel 2010

Dear Experts:

Why is the following menu item greyed out in Excel 2007/2010?
.... Format Chart Title / Alignment / Internal Margins

I would like to alter the internal margins using VBA. Is this
possible?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 587
Default Alter internal margins of chart title using VBA, Excel 2010

hi Andreas

try putting. ChartTitle.AutoScaleFont = False or True depending on the result desired


--
isabelle




Le 2011-09-15 18:18, AndreasHermle a écrit :
Dear Experts:

Why is the following menu item greyed out in Excel 2007/2010?
... Format Chart Title / Alignment / Internal Margins

I would like to alter the internal margins using VBA. Is this
possible?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Alter internal margins of chart title using VBA, Excel 2010

On Sep 16, 1:51*am, isabelle wrote:
hi Andreas

try putting. ChartTitle.AutoScaleFont = False or True depending on the result desired

--
isabelle

Le 2011-09-15 18:18, AndreasHermle a écrit :







Dear Experts:


Why is the following menu item greyed out in Excel 2007/2010?
... Format Chart Title / Alignment / Internal Margins


I would like to alter the internal margins using VBA. Is this
possible?


Help is much appreciated. *Thank you very *much in advance.


Regards, Andreas


Hi isabelle:

ok, thank you very much for your quick support. I will give it a try
tomorrow and let you know.

Regards, Andreas
Reply
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
Set color for chart serie in excel 2007/2010 Lina Excel Programming 5 May 6th 10 05:35 PM
Internal cell margins (Excel 2003) Helen Excel Discussion (Misc queries) 1 July 8th 09 01:51 AM
How do I use VB to adjust text box internal margins? BJD01 Excel Programming 1 March 2nd 09 09:07 PM
in an Excel table how do I set cell internal margins??? Brit in US Excel Discussion (Misc queries) 5 January 26th 09 04:29 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


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

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

About Us

"It's about Microsoft Excel"