×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

How Do I Link a Chart Title to a Cell?8

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?

RE: How Do I Link a Chart Title to a Cell?

I think all of the titles for a chart are like text boxes.  All you need to do is click the text box, then place your mouse pointer in the formula bar area, hit the equal sign and then place your mouse pointer in the cell you want to link to, then hit enter.

RE: How Do I Link a Chart Title to a Cell?

(OP)
Thanks, that's exactly what I was after.

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?

Yes you can create a formula with text & cell references. Enclose text within " and use & to connect to cell reference. for example if the pipe size is user input at cell C2 and say your title is at cell A5 in cell A5 wite the formula:

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

(OP)
Yeah, but I still have to assemble the title in cell A5 and then reference cell A5 in the title text box.  I can't just enter the formula ="Pressure Drop for "&C2&" Inch Pipe" in the title text box.

At least my computer's not letting me do it.

RE: How Do I Link a Chart Title to a Cell?

5
the answer to your question is "yes", a chart title can be linked to a value or text within 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.
-pmover

RE: How Do I Link a Chart Title to a Cell?

pmover,
I never knew that, thanks a lot!

RE: How Do I Link a Chart Title to a Cell?

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

GBinns,

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.

I have the same problem but when I reference a single cell  that displays $876,000 in bold letters, what I get is,876000. Is there any way to fix this problem? Thanks RE: How Do I Link a Chart Title to a Cell? Netdream, 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?

Thank you for the quick response.

RE: How Do I Link a Chart Title to a Cell?

p.s. if no link in textbox, then individual text can be formatted to your desire.
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?

As pmover said, boldface is not an option; you'll have to split the text into 2 cells.
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a partâ€™s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!