Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel vba chart build problem.
NickHK,
Thanks for the reply. No, I'm on W2k SP4 with Excel 2003 (11.6...) SP2 Jon |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to build a graph Chart | Charts and Charting in Excel | |||
build a chart in a cell | Excel Discussion (Misc queries) | |||
how to build a chart? | Excel Discussion (Misc queries) | |||
Chart being trashed after 5th build | Excel Programming | |||
excel 2002 build problem :( | Excel Programming |