By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,682 Members | 1,980 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,682 IT Pros & Developers. It's quick & easy.

How to get a chart title from a worksheet cell in c#?

P: n/a
ivo
Hello,
how do I link a worksheet cell with chart title field in c#?

Ivo

May 30 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
you need to say a little bit more than that to get help. the last psychic in
here quit...

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"ivo" <iv******@gmx.net> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
Hello,
how do I link a worksheet cell with chart title field in c#?

Ivo

May 31 '06 #2

P: n/a
ivo

Hi Alvin,

I am trying in c# to put a formula to chart title field:

chart.ChartTitle.Text = "=Sheet1!$A$1";

The result is, I get as title the text of field A1,
but only once. If I change A1 to another text,
the chart title would not change.
There is not any link/connection to worksheet.

Ivo

you need to say a little bit more than that to get help. the last psychic in
here quit...

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"ivo" <iv******@gmx.net> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
Hello,
how do I link a worksheet cell with chart title field in c#?

Ivo


May 31 '06 #3

P: n/a
"ivo" <iv******@gmx.net> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...
I am trying in c# to put a formula to chart title field:

chart.ChartTitle.Text = "=Sheet1!$A$1";

The result is, I get as title the text of field A1,
but only once. If I change A1 to another text,
the chart title would not change.
There is not any link/connection to worksheet.


I suggest you use the Excel Macro Recorder to create the VBA code for you
which will achieve what you want, then convert it to C#.
May 31 '06 #4

P: n/a
ivo
Mark,
sorry.
The code make by macro recorder can not be taken to c#.
The formula is not taken.
Ivo
Mark Rae schrieb:
"ivo" <iv******@gmx.net> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...
I am trying in c# to put a formula to chart title field:

chart.ChartTitle.Text = "=Sheet1!$A$1";

The result is, I get as title the text of field A1,
but only once. If I change A1 to another text,
the chart title would not change.
There is not any link/connection to worksheet.


I suggest you use the Excel Macro Recorder to create the VBA code for you
which will achieve what you want, then convert it to C#.


May 31 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.