Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to add a text box to the bottom left portion of a chart using Excel 2007 (the trial version downloaded from Microsoft). I could do this with Excel 2003 using the following code: Chheight = ActiveChart.ChartArea.Height Chtleft = ActiveChart.ChartArea.Left ActiveChart.TextBoxes.Add(Chtleft, Chheight, 10, 10).Select Selection.Characters.Text = "This is my text" Selection.autosize = true With Excel 2007, it will not place the text box below the x axis, no matter what value I put in for Chheight. And, I get an error message when trying to autosize the text box. Any ideas? Thanks, Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 text import as text not date | Excel Discussion (Misc queries) | |||
autofit text when resizing text box in Excel 2007 | Excel Discussion (Misc queries) | |||
text box in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Text Box | Excel Discussion (Misc queries) |