X Axis

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

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
 
Back
Top