Posted to microsoft.public.excel.charting
|
|
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.
|