View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel vba chart build problem.

Are you using XL 2007 ?
Some report strange (different) behaviour with that version and charts.

NickHK

"wimblejon" wrote in message
oups.com...
Hi there,

Has anyone come across this weird phenomenon?

I have some code in a macro as follows:

With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "SERVICE PACKAGE UTILISATION"
.ChartTitle.Top = 13
.ChartTitle.Left = 13
End With

....but it doesn't put the title to the left when I run the macro
using 'Run' or 'F5'. If I step through the code using "Step into" or
'F8' then it works fine!

Any ideas?

Thanks,

Jon