ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to lock a line put on a graph in excell (https://www.excelbanter.com/charts-charting-excel/104484-how-lock-line-put-graph-excell.html)

dennis

How to lock a line put on a graph in excell
 
I am trying to attach a line to a graph with months on the X axis. When I
add additional months I want the line to stay in between the original months,
however, it always moves as the graph expands.

Jon Peltier

How to lock a line put on a graph in excell
 
Drawing objects cannot be linked to specific values of chart axes, unless
you incorporate them as series in the chart. Try the techniques he

http://peltiertech.com/Excel/Charts/AddLine.html

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


"Dennis" wrote in message
...
I am trying to attach a line to a graph with months on the X axis. When I
add additional months I want the line to stay in between the original
months,
however, it always moves as the graph expands.





All times are GMT +1. The time now is 08:19 PM.

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