In the cell that your title/textbox links to, use a formula to construct the
static/dynamic text you want to display:

="Student Name: "&A1

then link to this cell as before.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AccessHelp" wrote in message
...
Peter,

Thanks for your help. I tried the way you instructed, and it worked.

However, there is a twist. I want to make my chart title (and text box)
both static and dynamic, which means a portion of my chart title is static
and the other portion is dynamic (e.g. Student Name: John Dole). "Student
Name" would be static, and John Dole would be dynamic from Cell A1 of Data
Sheet.

When I tried to input the formulas =concatenate("Student Name: ", 'Data
Sheet'!A1), I got an error "That Function is not valid.".

Is it possible to have a chart title and text box static and dynamic?

Thanks.

"Peter T" wrote:

I am just wondering whether I can make the chart title dynamic, which
means
whenever the value for chart title in the Data Sheet changes, the chart
title
will change.

Put the cursor in the Title
In the inputbar type an =
with the cursor still in the Input bar after the =, select the cell
(swithch
sheet if necessary)

In addition, I want to insert an area on the bar chart for the Source
information. I also want the source information dynamic from the value
from
the Data Sheet.

The source address is in the Series formula (select the series)

If you really want the address to show on the chart, enter the address as
a
string in some cell, perhaps a pair of =Address() worksheet functions.
Add a
textbox to the chart. Use the same method as described above for the
Title
to place the cell contents in the textbox. Not sure what you want but
FWIW
you could also add address's to Axis titles with the =Cell method.

Regards,
Peter T