Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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,
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default 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.
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.



  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Titles not showing in excel chart Greg_tnwre Excel Discussion (Misc queries) 1 July 28th 06 05:36 PM
Chart Titles not showing in excel chart Window Greg_tnwre Excel Discussion (Misc queries) 0 July 15th 06 03:41 AM
chart axis Titles seedbankstudy Charts and Charting in Excel 0 October 5th 05 06:41 PM
Dynamic Chart Titles Sharon Charts and Charting in Excel 6 May 1st 05 04:16 AM
Centering Axis and Chart Titles on chart saturnin02 Excel Discussion (Misc queries) 1 February 9th 05 10:28 AM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"