X Axis

Does anyone know a way to automatically draw the vertical
line that intersects with another plotted line using the XY
scatter charts

Depending on what you want to do, put the values in worksheet cells,
and plot them. Or, add another series at the appropriate value with
hard-coded values as in =SERIES(,{10,10},{0,100},<number one larger
than existing number of series in chart>), which will draw a vertical
line at x=10 extending from y=0 to y=100.

Or, and again depending on what you want to do, use the Interactive
Chart add-in, downloadable from my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <0b0501c3afc1$727b54a0$a001280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> Does anyone know a way to automatically draw the vertical
> line that intersects with another plotted line using the XY
> scatter charts
>
>