ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Anchoring Phase Change Lines (https://www.excelbanter.com/charts-charting-excel/260069-anchoring-phase-change-lines.html)

MS User

Anchoring Phase Change Lines
 
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

Anchoring Phase Change Lines
 
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?



All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com