Cesar Aracena
asked on
How to make a simulated *smooth* graphic in Excel or Access
Hi guys,
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!
simulatedgraph.png
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!
simulatedgraph.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks for the combination of formulas ;)
Click the line data series you want smoothly curved.
Go to Format and click Selected Data Series and go to the Patterns tab.
Select Smoothed line.