excel charts with scalable arrows

Question

excel charts with scalable arrows

pylandj1 (Mechanical)

(OP)

26 Oct 15 16:02

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?

Panars (Geotechnical) · Answer 1 · 2015-10-26 16:27:40

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

http://files.engineering.com/getfile.aspx?folder=80411ccd-6594-4046-951f-22

pylandj1 (Mechanical) · Answer 2 · 2015-10-26 16:34:07

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.

Panars (Geotechnical) · Answer 3 · 2015-10-26 16:49:06

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.

Come Join Us!

Posting Guidelines

Related Projects

Jobs

excel charts with scalable arrows