Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anchoring Excel Cells | Excel Worksheet Functions | |||
Phase change line on a graph? | Excel Discussion (Misc queries) | |||
inserting phase lines on a line graph | Excel Discussion (Misc queries) | |||
Anchor a phase change line? | Charts and Charting in Excel | |||
Anchoring Activex Controls | Excel Discussion (Misc queries) |