INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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.

Jobs

excel charts with scalable arrows

excel charts with scalable arrows

(OP)
Hi, I am trying to create an excel sheet for my company, which will be used for weld calcs.

I have an equal axis chart and a button that resizes the sketch of the cross section shape (T, C, I etc.)

After the first review cycle I have been asked to provide arrows on the cross section graph. Essentially it should be a live dimension arrow with a label that updates with the dimension.

I have seen this done, but I cannot find any example or mention of the topic online. Anyone know how to do this, or where I could find info?

RE: excel charts with scalable arrows

If you are using a recent version of Excel, just format the line style of a series to have arrows at one or both ends of the line. You can also create a data label for a point and link it to a cell on the spreadsheet for the dimension.
See the attached Excel file

RE: excel charts with scalable arrows

(OP)
Ok, I follow that, except how did you link the data label to the cell? I can only get it to show the default y value of the point.

RE: excel charts with scalable arrows

1. Click on the data label to select it.
2. Click in the edit box above the column numbers (letters).
3. Type "=" and then click on the cell you want to reference.
4. Hit Enter.

That should change the data label so it is a dynamic reference to the cell you select.

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!


Resources


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