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?
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
See the attached Excel file
RE: excel charts with scalable arrows
RE: excel charts with scalable arrows
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.