Line Graphs with significant events
 

I have a line graph that has big changes happening in data that I would like
to plot as a straight line from the X axis to the max value so I can label
the event that took place for this to happen. I could just draw a straight
vertical line but it stays in one place as more days of information is added.
I would like to tie this event to a specific date so that it moves. Any
ideas?

Line Graphs with significant events
 

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

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


"Duncan Help" wrote in message
...
I have a line graph that has big changes happening in data that I would
like
to plot as a straight line from the X axis to the max value so I can label
the event that took place for this to happen. I could just draw a
straight
vertical line but it stays in one place as more days of information is
added.
I would like to tie this event to a specific date so that it moves. Any
ideas?