×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

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

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?

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.
please advise status!
-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.

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

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.

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?

um,

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?

Thank you.

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?

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.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


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
Design for Additive Manufacturing (DfAM)
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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close