Concatenate in chart titles
 

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both. Thanks,

Answer: Concatenate in chart titles
 

1. Click on the chart to select it.
2. Click on the chart title to select it.
3. In the formula bar at the top of the Excel window, type the following formula:
   Formula:

   ---

   ="Text " & A1 


   ---

   
   (Note: replace A1 with the cell reference that you want to include in the title.)
4. Press Enter to apply the formula to the chart title.

This formula uses the ampersand (&) symbol to concatenate the text "Text " with the contents of cell A1. You can replace "Text " with any other text that you want to include in the title.

Once you have applied the formula to the chart title, it will display the concatenated text and cell reference. If the contents of cell A1 change, the chart title will update automatically to reflect the new value.

Concatenate in chart titles
 

On Sat, 12 Jan 2008, in microsoft.public.excel.charting,
Mike Z said:

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both.

You can't make the title be a formula, but you can make it be "contents
of a referenced cell".

So make it be the contents of a cell which is *itself* a formula. That
referenced cell can be "Text & 'contents of another referenced cell'"
easily.

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

Concatenate in chart titles
 

Hi Mike,

Del has given you the correct solution. I just wanted to clarify:

In a spreadsheet cell enter a formula such as:

="The result is: "&B2&" as of "&TEXT(NOW(),"DDDD - MMM. D, YYYY")

This example shows you how to concatenate text with a cell's contents with a
function's results. Many books state that you can only concatenate text
entries but you can concatenate numbers, dates, text, cell references,
formulas and functions.


--
Cheers,
Shane Devenshire


"Del Cotter" wrote:

On Sat, 12 Jan 2008, in microsoft.public.excel.charting,
Mike Z said:

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both.

You can't make the title be a formula, but you can make it be "contents
of a referenced cell".

So make it be the contents of a cell which is *itself* a formula. That
referenced cell can be "Text & 'contents of another referenced cell'"
easily.

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

Concatenate in chart titles
 

That worked great. Thank you so much.

"Del Cotter" wrote:

On Sat, 12 Jan 2008, in microsoft.public.excel.charting,
Mike Z said:

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both.

You can't make the title be a formula, but you can make it be "contents
of a referenced cell".

So make it be the contents of a cell which is *itself* a formula. That
referenced cell can be "Text & 'contents of another referenced cell'"
easily.

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

Concatenate in chart titles
 

That worked great. Thanks a bunch.

"ShaneDevenshire" wrote:

Hi Mike,

Del has given you the correct solution. I just wanted to clarify:

In a spreadsheet cell enter a formula such as:

="The result is: "&B2&" as of "&TEXT(NOW(),"DDDD - MMM. D, YYYY")

This example shows you how to concatenate text with a cell's contents with a
function's results. Many books state that you can only concatenate text
entries but you can concatenate numbers, dates, text, cell references,
formulas and functions.


--
Cheers,
Shane Devenshire


"Del Cotter" wrote:

On Sat, 12 Jan 2008, in microsoft.public.excel.charting,
Mike Z said:

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both.

You can't make the title be a formula, but you can make it be "contents
of a referenced cell".

So make it be the contents of a cell which is *itself* a formula. That
referenced cell can be "Text & 'contents of another referenced cell'"
easily.

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