TechArena Community Smooth curve in Excel

#1
24-03-2009
 Member Join Date: Nov 2005 Posts: 103
Smooth curve in Excel

I need to make some graphs (characteristic of a diode) and I know there is a function in Excel to have a smooth curve, which plotted as an average between the measurement points. Do you know how this function is called?
#2
24-03-2009
 Member Join Date: Dec 2007 Posts: 1,592
Re: Smooth curve in Excel

The smoothing in Excel is made via splines: you take 3rd degree polynomials, and adjust their four coefficients with the need of continuity, and smooth 1st and 2nd order derivatives. Then you would have to create sufficient points from those polynomials, so that you can see the curve really smoothed.
#3
24-03-2009
 Member Join Date: Dec 2007 Posts: 1,542
Re: Smooth curve in Excel

Using smooth curves is deceptive. I like to see the data and decide for myself, or with the help of real curve fitting, how the variables are related.
#4
24-03-2009
 Member Join Date: Dec 2007 Posts: 1,728
Re: Smooth curve in Excel

Here's another answer. When you create curves using the bezier tool you can change mode from create to edit and select a point(s) click on it and adjust the handle(s) to smooth out the curve....In case you are unaware of that.

 Tags: excel