Anchoring Phase Change Lines
in [Charts]
|
From: MS User on 27 Mar 2010 12:57 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?
From: PBezucha on 29 Mar 2010 03:44 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 -- Petr Bezucha "MS User" wrote: > 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?
|
Pages: 1 Prev: Sorting PivotChart data Next: Fix poor image quality when pasting from excel to powerpoint? |