Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 120
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anchoring Excel Cells stockwsr Excel Worksheet Functions 2 July 15th 08 07:00 PM
Phase change line on a graph? tobyhons Excel Discussion (Misc queries) 1 May 16th 06 08:25 PM
inserting phase lines on a line graph tobyhons Excel Discussion (Misc queries) 0 January 10th 06 03:29 PM
Anchor a phase change line? skinnerbox99 Charts and Charting in Excel 1 August 6th 05 12:12 AM
Anchoring Activex Controls KG Excel Discussion (Misc queries) 2 March 24th 05 07:51 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"