Results 1 to 4 of 4

Thread: Smooth curve in Excel

  1. #1
    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. #2
    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. #3
    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. #4
    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.

Similar Threads

  1. Replies: 8
    Last Post: 07-02-2012, 06:59 PM
  2. Need help to plot logistic curve in Microsoft Excel
    By GuruT in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 04:53 PM
  3. Searching for template of bell curve graph in excel
    By Rao's in forum Windows Software
    Replies: 2
    Last Post: 06-01-2012, 01:04 PM
  4. S-curve exported to excel
    By Lima Jaric in forum Microsoft Project
    Replies: 2
    Last Post: 23-09-2010, 04:25 PM
  5. Replies: 2
    Last Post: 24-04-2009, 07:36 AM

Posting Permissions

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