|
| |||||||||
| Tags: excel |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| ||||
| ||||
| 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
| ||||
| ||||
| 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.
__________________ Education, Career and Job Discussions |
|
#3
| ||||
| ||||
| 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
| ||||
| ||||
| 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. |
![]() |
|
| Thread Tools | Search this Thread |
| |
Similar Threads for: "Smooth curve in Excel" | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help to plot logistic curve in Microsoft Excel | GuruT | MS Office Support | 2 | 1 Week Ago 05:53 PM |
| Searching for template of bell curve graph in excel | Rao's | Windows Software | 2 | 06-01-2012 02:04 PM |
| Does the Blackberry Curve have Microsoft Word, Excel and Powerpoint applications ? | Ameeryan | Portable Devices | 3 | 08-08-2009 12:28 AM |
| Vertical scrolling...jumps rather than smooth scrolling - Excel 20 | Miller Man | Vista Hardware Devices | 4 | 24-04-2009 08:36 AM |
| S-curve exported to excel | labingtone | Microsoft Project | 1 | 21-03-2008 09:30 AM |