Log interpolation between two points

PetiteFille

New Member
Hi!

I have a series of points that look like this:
X Y
2% 45%
17% 30%
80% 17%
110% 9%
150% 2%

I want to create a smooth graph with these data but I don't want to have to create a LOGEST function between each points to simulate b and m since I have 20 series like this to graph..

Is there a way to do this in either vba or excel?

Thank you in advance!
 

Some videos you may like

This Week's Hot Topics

Top