Sue -
Another way, if you wanted an actual line, is to follow one of these
techniques, using a variation on Barb's formulas to determine where the
line should be positioned.
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Sue wrote:
I am working with finance data which I put into line graphs. Is there anyway
to identify the current month without having to manually put in and move a
line in 30plus graphs?