+ Reply to Thread
Results 1 to 6 of 6

Making a line graph into a curve graph & finding the area

  1. #1
    Registered User
    Join Date
    03-22-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Making a line graph into a curve graph & finding the area

    Hi guys,

    Please refer to the attachment.

    I want to plot a curve graph instead of a straight line graph.
    And how do i find the area under the graph?

    Thanks in advance
    Attached Files Attached Files
    Last edited by AppleMonster; 03-27-2014 at 06:15 AM.

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Making a line graph into a curve graph & finding the area

    you need to calculate the area mathematically, not graphically. Use the integral of the function with the limits that you plot

    e.g. f(x)=x then integral of the f(x) is 1/2 * x^2 with the limits from 0 to 50 you get the area: 1250
    Click on the star if you think I helped you

  3. #3
    Registered User
    Join Date
    03-22-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Making a line graph into a curve graph & finding the area

    Alright thank Adyteo, what about making the 1st line curve?

  4. #4
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Making a line graph into a curve graph & finding the area

    in order to look like a curve, you need more points between the existing ones in order for the segments to be small enough to blend into a curve.
    because I do not believe it can be described by a single equation, in order for you to calculate the area, you will need to break the graph into few subgraphs and then calculate the areas for each subgraph.

  5. #5
    Registered User
    Join Date
    03-22-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Making a line graph into a curve graph & finding the area

    Thanks Adyteo, So there's no way to automatically make it curve except inserting more points?

    Ok Thanks alot-

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Making a line graph into a curve graph & finding the area

    Visually you can smooth the line via the Format dialog, but that will make the area under the curve incorrect.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-23-2008, 09:49 PM
  2. Area beneath (or above) curve on graph
    By Billybob4900 in forum Excel General
    Replies: 2
    Last Post: 06-18-2006, 07:35 AM
  3. Replies: 8
    Last Post: 12-20-2005, 06:00 PM
  4. How do I calculate the area under a curve in an Excel graph?
    By Suzanne Graham in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-07-2005, 09:05 AM
  5. [SOLVED] finding the area under the curve in a graph in excel
    By rmento in forum Excel General
    Replies: 1
    Last Post: 02-09-2005, 06:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1