Anchoring Phase Change Lines

[MS User]

How do you anchor phase change lines or text boxes to the horizontal axis so
that, as you add additional data, they maintain their position relative to
the horizontal axis when the chart is redrawn with the additional data?

 

[PBezucha]

Phase change line is a line like whichever else. Therefore it must be
declared by a series of points read from a table of xy pairs; either fixed or
calculated by an equation valid within some limits (let them be chart
boundaries or mutual intersections). If you intend your textboxes for the
descriptions of phase fields, the way you want them to respond to any change
of axes scale may be using text labels bound to colorless (…ColorIndex =
xlNone) auxiliary points.

Regards