LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default How to add a title to a chart by means of Excel automation?

It's easy when using VBA code, like,
..ChartTitle.Characters.Text = "Hello"

But, setting a Text or Characters property of chartTitle always got an
exception. Is it possible doing that?

code excerpt in vb.net

objChart = objSheet.ChartObjects.Add(50, 40, 300, 200).Chart
objChart.SetSourceData(Source:=objSheet.Range("A1" ).Resize(cNumRows,
cNumCols))
objChart.ChartTitle.Characters.Text = "Hello" <---- here!!!

Thx in advance.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone know what "[VSync]" appended to filename title means? Excel Ant Excel Discussion (Misc queries) 1 July 1st 09 03:58 PM
Automation of Dynamic Chart Title and legend changes Boon8888 Charts and Charting in Excel 1 February 3rd 06 11:00 PM
Excel chart - how to assign the file name in the chart title? TGreen Charts and Charting in Excel 1 August 16th 05 10:35 AM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM
What means [Group] in the title bar of a workbook Gabriel Martin Excel Discussion (Misc queries) 4 December 8th 04 10:35 AM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"