How Do I Link a Chart Title to a Cell?
How Do I Link a Chart Title to a Cell?
(OP)
I would like to link an Excel chart title to a cell in a worksheet. Does anybody know how to do this?
In other words, I have a spreadsheet cell that changes based on inputs from the user. I want the title of my chart to change with that cell.
E.g.: My cell in question reads, <4"> and I want my chart title to read, <Pressure Drop for 4" Pipe>. And I want the title to change to 6" pipe if that's what the user inputs. I know about the concatenate command, but I don't know how to use it in a chart title.
Can anyone help me out, please?
In other words, I have a spreadsheet cell that changes based on inputs from the user. I want the title of my chart to change with that cell.
E.g.: My cell in question reads, <4"> and I want my chart title to read, <Pressure Drop for 4" Pipe>. And I want the title to change to 6" pipe if that's what the user inputs. I know about the concatenate command, but I don't know how to use it in a chart title.
Can anyone help me out, please?
RE: How Do I Link a Chart Title to a Cell?
RE: How Do I Link a Chart Title to a Cell?
Too bad, though, I can't use a fomula inside a text box. I have to have the formula inside the worksheet cell, and then refer to that cell in the text box.
RE: How Do I Link a Chart Title to a Cell?
="Pressure Drop for "&C2&" Inch Pipe"
I had to write out inch but see if the formula below will work
="Pressure Drop for "&C2&"""&" Inch Pipe"
note blank within the quote marks will show up as a space
RE: How Do I Link a Chart Title to a Cell?
At least my computer's not letting me do it.
RE: How Do I Link a Chart Title to a Cell?
1) simply create the chart and insert a "dummy" chart title.
2) select the chart title (not the text within the title) - do NOT have the blinking cursor within the textbox, but the textbox itself.
3) type "=" (w/o quotes), like entering a formula, and then select the cell with information to be displayed.
when the cell value is changed, so is the chart title.
this procedure does apply to other textboxes on charts, including datalabels.
i frequently accomplish this task, so no big deal.
please advise status!
-pmover
RE: How Do I Link a Chart Title to a Cell?
I never knew that, thanks a lot!
RE: How Do I Link a Chart Title to a Cell?
glad to have provided a tip!
i've been using that feature for quite awhile - especially for monitoring equipment performance (i.e. equipment id # is chart title or some other textbox within chart).
-pmover
RE: How Do I Link a Chart Title to a Cell?
You are right, you can only reference a range (which may consist of multiple cells) in a text box. A formula with concatenations (&'s) just isn't supported. Not even when you make up a Name definition containing the formula and then reference the Name in the text box.
Too bad, should be nice in a future version of Excel...
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: How Do I Link a Chart Title to a Cell?
Is there any way to fix this problem?
Thanks
RE: How Do I Link a Chart Title to a Cell?
if you are attempting to get the dollar sign (or any other character), enter the following formula in a cell. then create the text on the chart and then create the link as previously posted.
="minimum dollar ="&" $"&FIXED(C9,2)
in this example, cell c9 contains the minimum function. the formula uses xl's standard concatenate capabilities to combine text strings and numbers.
-pmover
RE: How Do I Link a Chart Title to a Cell?
For the dollar sign it may work, but this trick it will not work for the comma; $827,000
I am also trying to point to a cell that has a date "June 30, 1998", and it is not working: Any idea why?
RE: How Do I Link a Chart Title to a Cell?
the comma was inserted when i tried it. perhaps the version of excel, how you have excel setup, or how your pc regional settings are established is the reason why the comma does not show.
cell value is: 827000
formula is: ="minimum dollar ="&" $"&FIXED(D4,2)
result is: minimum dollar = $827,000.00
as far as the date is concerned, you probably get something like this:
cell value is: 30-Jun-98
formula is: ="date is:"&FIXED(D9,2)
result is: date is: 35,976.00
well, u need to convert the date to text.
formula is: ="date is:"&TEXT(D9,"mmm dd, yyy")
result is: date is:Jun 30, 1998
good luck!
-pmover
RE: How Do I Link a Chart Title to a Cell?
This is very helpful;
I really appreciate it!!!
George
P.S. One last thing; is there anyway that I can make only $827,000 appear in bold letters?
RE: How Do I Link a Chart Title to a Cell?
if there is a link, then entire text message or link can be formatted to your desire - not text specific.
to change formats, make selection and right-click to get sub-menu, and select format text box.
-pmover
RE: How Do I Link a Chart Title to a Cell?
Instead of the FIXED function, you can also try:
cell value is: 827000
formula is: ="minimum dollar ="&DOLLAR(D4,2)
result is: minimum dollar = $827,000.00
or
cell value is: 827000
formula is: ="minimum dollar ="&TEXT(D4,"$#,##0.00")
result is: minimum dollar = $827,000.00
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.