Cylindrical Milestone Text Placement

[Antje]

Hi,
I am trying to change the text location of a cylindrical milestone. I want
to move it from above the marker to display beside the marker. What do I need
to change in the Shapesheet to accomplish this?
Also, can somebody please explain the formula below?
=IF(IF(User.visIsPin,Sheet.33!Controls.Row_2.Y,Sheet.33!Controls.Row_1.Y)-Sheet.33!Height>0,1,0)

TIA.
Regards,
A. Crawford

 

[Philippe C.]

Hard to answer, because we don't know your knowledge level.

Do you absolutely want to move the text location in the Shapesheet. It can
be done by dragging the yellow diamond. Maybe the line is a problem ?

For the if function :
http://msdn2.microsoft.com/en-us/library/aa199814(office.10).aspx

Look for the colons in the formula and rewrite it with an understandable
layout.

User.visIsPin is not in my milestonde shape. It is a user cell. Look at
its formula.
I can only suppose that is evaluates if something had something to do with a
Pin.
And Controls are the yellow diamonds.

 

[Paul Herber]

Hi,
I am trying to change the text location of a cylindrical milestone. I want
to move it from above the marker to display beside the marker. What do I need
to change in the Shapesheet to accomplish this?

As Philippe said, there are two yellow diamonds between the red ) and
the text, moving these moves the line from the ) to the text. You can
then move the text to wherever you want.

Also, can somebody please explain the formula below?
=IF(IF(User.visIsPin,Sheet.33!Controls.Row_2.Y,Sheet.33!Controls.Row_1.Y)-Sheet.33!Height>0,1,0)

If you open the shapesheet for the text part of the shape and from the
right-click menu select Values rather than Formulas, it should show 1,
leaving the shapesheet window open, now go back to the main diagram
window, select the milestone shape and move the yellow diamond nearest
the text, move it to below the timeline, the value will change to 0.
So, what it's doing is calculating whether the diamond is above or
below the timeline.
But you don't want to go there!

 

[Philippe C.]

I learned a lot.
Now I found the concerned user cell.
It is called User.visAboveMarker