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: 39
Default Chart properties

I'm setting a whole list of properties for my chart, however the font.size
does not get set if Application.ScreenUpdating = false. Here is an example of
the code:

With ActiveChart.Axes(xlValue)
.AxisTitle.Font.FontStyle = "normal"
.AxisTitle.Font.Size = 11 'does not get set
.TickLabels.Font.Size = 11 'does not get set
.MajorGridlines.Delete
.MinimumScale = -25
.MaximumScale = 125
.Crosses = xlAutomatic
End With

Why is this? I really prefer to keep the Application.ScreenUpdating = false.

Thanks
The Doctor
 
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
Change Chart Properties for Multiple Chart Shts using a Worksheet KUMPFfrog Charts and Charting in Excel 0 July 22nd 09 11:01 PM
Recovering chart properties in vba Bob Charts and Charting in Excel 1 November 24th 06 05:19 PM
How to control chart properties from worksheet Marko Pinteric Excel Discussion (Misc queries) 3 April 5th 06 12:38 PM
How to control chart properties from worksheet Marko Pinteric Charts and Charting in Excel 1 April 5th 06 12:38 PM
Setting up default chart properties CraigB Excel Programming 1 August 24th 04 04:34 AM


All times are GMT +1. The time now is 02:15 PM.

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"