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
 
You must log in or register to reply here.

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

Similar Threads

How do I adjust marker spacing in Excel scatter plot? 1
Odd chart type needed 2
Swapping X and Y Axis - line Chart 3
Colour plot area of a dual axis x,y chart 3
How do I put words as the Y axis values? 0
Plotting Date and Time on the same chart axis 1
xy scatter - dates off 4
Vertical line in stock chart 1

Back
Top