Del,

Thanks for your response. I thought about that, and I was hoping that I
don't have to take that route.

I have a few text boxes, and the static values are different for each text
box. However, the dynamic value is the same for all text boxes.

Thanks again.

"Del Cotter" wrote:

On Sun, 17 Feb 2008, in microsoft.public.excel.charting,
AccessHelp said:
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.".

Lateral Thinking time: if formulas aren't possible in the Chart box
(they aren''t, only a simple cell reference) then have the chart box
refer to a cell which is itself a formula.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.