Problem: XY scatter chart????

  • Thread starter Thread starter ns04
  • Start date Start date
N

ns04

I have to find the X-intercept on y-axis and y-intercept on the x-axi
and display the intersection on the XY scatter chat as well as show th
intercepts using dotted line.

Can anyone help me with this.

Thanks a ton
 
Intercepts of what? The piece-wise linear line segments that XL uses to
connect points in a scatter chart? The smoothened line that XL is
capable of drawing? The trendline? If so, what kind?

For the first, use the points that straddle the x (or y) axis and
calculate the value for y=0 (or x=0). If no such points exist, you will
have to extrapolate using the equation for the nearest set.

For the 2nd, check the google.com archive of the XL newsgroups for posts
on algorithms to duplicate XL's smoothening process.

For the last, create the trendline of interest, show its equation on the
chart, increase the precision of the results (double-click the equation
on the chart, then from the Numbers tab increase the number of
decimals), and use that to calculate the x (or y) values corresponding
to y=0 (or x=0).

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top