If you have a XY Scatter chart, plot the series
=SERIES(,{x-val,x-val},{0,max-y-val}.{series number})
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"dsears" wrote:

I want to draw straight verticle lines from the X axis. Autoshape allows
verticala lines, however, they are only as straight as one can do with the
mouse. Old dos based Quatro Pro provided the means to accomplish this,
however, I have not found a way in Excel 2003. Help.