Access Chart Title and Axis title and Legend

[iccsi]

I have an application to support 2 languages.

I store the language in the table.

I would like to know to access all title and text in the chart to
change text accrordingly.


Can I access the titles and text in the chart?


Your help is great appreciated,

 

[george 16-17]

Greetings iccsi,

I have recently been working with graphs, but I am a novice myself. You can
change the chart title of with a little VBA -

With Me.graph1.Object.Application.Chart
.ChartTitle.Text = Me.txtbox.value
End with

For additional help see:
http://www.vb123.com/toolshed/99_graphs/msgraph1.htm
http://support.microsoft.com/kb/186855

HTH,
george