Excel coordinates

W

wysz

I would love to know how to get Excel to read the coordinates at a point on a
graph, BETWEEN the data points.

Thanks muchly

Jeff
 
J

Jerry W. Lewis

Excel's chart smoother appears to use Bezier curves. Brian Murphy has
posted code for Bezier curves, but the link he gave
http://www.xlrotor.com/excel_stuff.htm
appears to be obsolete. I

In most cases, the difference between Bezier curves and cubic splines is
minimal. An example where the difference is noticeable is
http://www.google.com/groups?threadm=3E7291CA.7020907@no_e-mail.com
David Braden has posted code for cubic splines, but Google changed their
addressing and my saved link is now broken. You might find it by searching.

I could e-mail you a .zip file of Brian Murphy's workbook and David
Braden's VBA code if you like.

Jerry
 
W

wysz

Jerry, that would be great if you could email those. my address is wysz
(at) hotm ail (dot) com

I saw refference to a program (Excel utility) in my searching called
Chartool that is apparently based on Bezier curves , but only broken links
were attached to refferring links.
 
J

Jerry W. Lewis

E-mailed privately.

Jerry
Jerry, that would be great if you could email those. my address is wysz
(at) hotm ail (dot) com

I saw refference to a program (Excel utility) in my searching called
Chartool that is apparently based on Bezier curves , but only broken links
were attached to refferring links.


:
 

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