Have you ever wondered what formula Excel uses to make its “curved line” scatter plots? I have!
Admittedly, this sounds like an odd thing to wonder about. But it’s actually a super-practical question: what if you want to approximate an intermediate point along the curve you have just plotted? For some reason, Excel hides this formula from you, and according to my source post, Microsoft has left this formula a black-box and given users no access to it. WTF, mate. Continue reading Mystery solved! The secret of Excel curved line interpolation
You must be logged in to post a comment.