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?

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?

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?

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?
|
|
|
|

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?
|
|
|
|

Works fine thanx

"Tom Ogilvy" wrote in message
...
| 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?
| |
| |
| |
| |
|
|
|
|