You didn't step on my toes (whatever you mean by that). What you suggested
doesn't work fort he question asked.

--
Regards,
Tom Ogilvy

"Andrew" <NoToSPAM@home wrote in message
...
Sorry tom didn't mean to stand on your toes..!
"Tom Ogilvy" wrote in message
...
| You need to construct your string in a cell and then reference the
results
| with the textbox on the chart.
|
| You need to put that formula in a separate cell, for example K50
|
| then select the chart and in the formula bar put in
| =Sheet1!K50
|
| You can't have complex formulas in textboxes.
|
| --
| Regards,
| Tom Ogilvy
|
| "Andrew" <NoToSPAM@home wrote in message
| ...
| Type this formula in the formula bar:
|
| ="Permanent Occupancy:" & K35 & ", Temporary Occupancy:" & K48
| use quotes to define text, and the & to concatenate with formulae.
|
| HTH
| -----
| Andrew
| Durham
|
| "Phil Hageman" wrote in
message
| ...
| | Cell M35 and K48 contain numbers. I want to put a text box in a
chart
| | saying: "Permanent Occupancy" and the K35 value, "Temporary
Occupancy"
| and
| | the K48 value. The result would be like: Permanent Occupancy 100,
| Temporary
| | Occupancy 245. What would the formula be?
|
|
|
|