| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
