I am on the verge of releasing an Excel-based application for tanning
salons and spas. This is the mother of applications, but I need to add
automation to my graphs.

I need to automate the graphs that I have in my application so that
the title automatically reflects:

1. Customer Name
2. Subject of Graph
3. Date Covered By Graph

My application already has the customer name and date appear at the
top of each spreadsheet. My problem is taking that information and
using it so that it appears in the title of my graphs.

I need someone who nows how to do this and can show me how to do this
either in person or over the telephone. I am willing to pay for this
service. Show me how to do one and I can do the rest.

If you live within the San Francisco Bay Area this would be better.

You may contact me through my email which is:



Please leave your name, where you live and a telephone number plus
best time to reach you.

I need to have this done ASAP.

Sincerely,



Marcello

At the risk of pointing out something you may have already tried, have
you considered using:

With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = jm_title
End With

You can set jm_title to be anything - either by proimpting the user to
enter his/her details or by obtaining them automatically from the
system

eg:

jmtitle=graph_subject + Application.UserName + cstr(Date)

I havent tried to but you should be able to segment the title into
separate lines using the carrage return ascii code eg:


jmtitle=Application.UserName + chr(13) + graph_subject + chr(13)+
cstr(Date)


I don't live in San francisco but you can post a beer to london if this
is at all helpful.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

You can also build the desired chart title in the worksheet, and link
the title to it:

With ActiveChart
.HasTitle = True
.ChartTitle.Text = "=Sheet1!R6C6" ' Cell F6
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

jmoffat wrote:
At the risk of pointing out something you may have already tried, have
you considered using:

With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = jm_title
End With

You can set jm_title to be anything - either by proimpting the user to
enter his/her details or by obtaining them automatically from the
system

eg:

jmtitle=graph_subject + Application.UserName + cstr(Date)

I havent tried to but you should be able to segment the title into
separate lines using the carrage return ascii code eg:


jmtitle=Application.UserName + chr(13) + graph_subject + chr(13)+
cstr(Date)


I don't live in San francisco but you can post a beer to london if this
is at all helpful.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/