ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Anchor a phase change line? (https://www.excelbanter.com/charts-charting-excel/38916-anchor-phase-change-line.html)

skinnerbox99

Anchor a phase change line?
 
Does anyone know how to anchor/lock in place a phase change line on a chart
so that it will stay in place when new data/data points are added?

Jon Peltier

Is this a series (which should stay put) or a drawn line (which is
likely to move wherever it wants)? Make a set of X-Y points where the
phase change line should be, and add a new series using this data. Since
it's built with data, it will stay anchored to the axis scales.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


skinnerbox99 wrote:

Does anyone know how to anchor/lock in place a phase change line on a chart
so that it will stay in place when new data/data points are added?



All times are GMT +1. The time now is 01:33 PM.

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