I'm working on a new project for my company and I need to create simulated graphs which will be used to test and foreseen real data. The graphs should be smooth curves as shown in the attached image. I've tried using different methods to create bell and gaussian curves but nothing really convince me.
What I need is to be able to input 5 or 6 different points and the curve should be created having in mind that is should be smooth... not plotted as square lines. Is it possible?
My final goal is to have that in Access so I can input all data in a form, lick a button and have the plot printed but I guess I'll be able to do that once I have the formula I need in Excel.
Is it possible?
Thanks in advance!