Excel vba chart build problem.
 

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

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

Excel vba chart build problem.
 

NickHK,
Thanks for the reply.
No, I'm on W2k SP4 with Excel 2003 (11.6...) SP2

Jon

Excel vba chart build problem.
 

Works for me, Excel 2003 SP2, WinXP SP2.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"wimblejon" wrote in message
oups.com...
NickHK,
Thanks for the reply.
No, I'm on W2k SP4 with Excel 2003 (11.6...) SP2

Jon