View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dotNeter dotNeter is offline
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.