Resizing a Shape based On Text Callout in its associated Data Graphic

[Lizzy]

Hi All,

Is there a way to cause a Parent Shape to grow in size based on the amount of text in a Callout? I have tried to edit the (Shape Transform) Width and Height cells in both the Callout and Parent (target shape) ShapeSheets, but I must not be getting the syntax right, or I am in the wrong place.

Currently the Parent values are:
Width = 1.4921 in.
Height = 0.5906 in.
The Callout values are:
Width = Sheet.162!Width*0.9215
Height = =GUARD(MAX(9 pt*DropOnPageScale,TxtHeight)+User.CalloutMargin*2)

I am trying to get the Height to set itself to 0.5906 unless there is more text, then have it resize accordingly. I want the Width to remain fixed.

Any advice would be greatly appreciated!

Lizzy