Text orientation with data graphics and linked data

[Wim_G]

After I found the solution to my previous problem (see here: http://visguy.com/vgforum/index.php?topic=6226.0 ) I now ran into a new issue:
To visually represent an MPLS cloud (for those who don't know what that is, it's a network thing) with several dozen sites I need to rotate some of the shapes.
However the text field configured by the data graphic is completely fixed to the shape and I can not rotate it separately nor can I assign it a fixed orientation.
Can this somehow be done?
See the attached images as a simple example of what I mean.

VisioEx1.png = what I get
VisioEx2.png = what I want


Thanks in advance for any suggestion,
Wim.

[Paul Herber]

Open the Drawing Explorer window, expand to see the shapes, select the shape, and expand it, you will see a sub-shape "Text callout", open its shapesheet and in the Angle cell enter the formula
-ANG360(sheet.n!Angle)
where sheet.n is the sheet name of the shape displaying the data.

[Wim_G]

Paul,

Awesome quick and excellent answer.
I did need to make a minor change to the formula though : =ANG360(Sheet.1!Angle-90 deg)

edit: oops ... let me gat back to you ... not quite what I was expecting when I rotate it some more

2nd edit: so your formula was exacltly spot on, I forgot the leading minus which is rather important (now for obvious reasons after researching this a little). At first I just happened to be at an angle where the addition of "-90deg" gave a good result in the absence of the leading minus.

Thanks!