X Axis

B

Bruce

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

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top