URGENT - NEED EXCEL PROGRAMMER OR PRO - HOW TO CHANGE TITLES ON CHARTS AUTOMATICALLY - HELP

[Marcello do Guzman]

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:

(e-mail address removed)

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

 

[Alan]

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:

(e-mail address removed)

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

No need to pay for something very simple!

First, make sure that the information you want in the chart title is
all together, in a single cell somewhere. You'll probably need to
concatenate and use the TEXT function to get it right.

Next, select your chart, and specifically, the chart title.

Click in the formula bar, and type = then click on the cell containing
the title info that you created above.

Then finally click on the tick to the left of the formula bar.

That will now transfer the cell contents (text) to the chart title.
If the cell contents change, then so does the title.

HTH,

Alan.