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
|