Excel - Cardinal spline & Cubic spline & Monotone Cubic Spline UDF

The demo file contains Cardinal Spline & Cubic Spline & Monotone Cubic Spline UDF that create curves that go exactly through all your data points. The advantage of a monotone cubic spline is that it does not 'wobble'.

Download demo file   (125kB - downloaded 945 times - Latest version: 2021-10-19, now including three splines)



MS Excel VBA code to be put in a module

In MS Excel, press Alt+F11 to open the Visual Basic Editor (Windows). Via top menu: Insert → Module. Copy the MS Excel VBA code of the functions into the module.

Cardinal spline


Cubic spline


Monotone cubic spline