View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank M. Walter Frank M. Walter is offline
external usenet poster
 
Posts: 6
Default How to link a chart title to a worksheet cell c#?

Hello,

it is possible to link a chart title to a cell via vba macro:

Sub Makro2()
ActiveSheet.ChartObjects("Diagramm 1").Activate
ActiveChart.ChartTitle.Select
Selection.Text = "=Tabelle1!R1C3"
End Sub

How do I do this in c#?

Just puting this code
string newTitle = "=Tabelle1!R1C3"

chart.ChartTitle.Text = newTitle.ToString() ;

....gets only the content of existing cell and puts ot to chart title.

The formula is not getting.



Thanks
Frank