PC Review


Reply
Thread Tools Rate Thread

Access Chart Title and Axis title and Legend

 
 
iccsi
Guest
Posts: n/a
 
      15th Dec 2008
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,

 
Reply With Quote
 
 
 
 
george 16-17
Guest
Posts: n/a
 
      16th Dec 2008
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


"iccsi" wrote:

> 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,
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Zero values not legend, Value grater then zero show data and legend Pamela Microsoft Excel Misc 0 27th Jan 2009 11:29 PM
merge axis title with legend =?Utf-8?B?c2NvdHQ=?= Microsoft Excel Charting 0 18th Oct 2007 08:09 PM
Pasting Objects into Chart title and Axis title =?Utf-8?B?U2Ft?= Microsoft Excel Charting 1 6th Jun 2005 08:50 PM
Chart Legend: Include more Data in my chart legend than what I have graphed eliese0 Microsoft Excel Charting 2 9th Aug 2004 11:30 PM
Aligning title, legend, x axis title on chart Ann Scharpf Microsoft Excel Charting 1 11th Nov 2003 07:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:03 PM.