Auto Size Shape?

Endlessknight

New Member
Joined
Oct 28, 2016
Messages
36
Greetings All,

I was wondering if there was a way to auto size a shape that's overlayed on a graph. I have a series of graphs like the type shown below.

FRD.png



The data that drives the charts changes often and thus the middle bar resizes itself but the arrow has to be manually changed each time.

FRD2.png



Is there any way to get the arrow to auto resize to the top of the bar whenever the bar changes?

Thanks in advance for any input/help.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
I'm sorry but I didn't explain that very well. What I'm looking for is a way to set the height of the arrow graphic to always but equal to the height of the middle bar, such that when the bar changes size the arrow would also.

Thanks.
 
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,195
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top