# Thread: Smooth curve in Excel

1. 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. Member
Join Date
Dec 2007
Posts
1,602

## 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. Member
Join Date
Dec 2007
Posts
1,548

## 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. Member
Join Date
Dec 2007
Posts
1,742

## 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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•