Getting value on other axis

  • Thread starter Thread starter GunnarF
  • Start date Start date
G

GunnarF

I have XY scatter chart with data points connected by smooth lines. Values
on X axsis are in the range from 0 to 1. Is there any way in Excel to find a
value on Y axis corresponding to any value form 0 to 1 on X axsis based on
plotted curve?

Thank you,

Gunnar
 
You will have to build your own solution. If you visit
http://xlrotor.com/, you'll find a link to the bezier curve method that
mimics XL's smooth curves.

If you want to use step wise linear interpolation, check out the
Interactive Chart add-in available from my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top