+ Reply to Thread
Results 1 to 4 of 4

Average Line

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    2

    Average Line

    Hello everyone,
    I have some Stress-Strain charts of steel Fibres in Concrete ( 6 tests - check the attachement) the X axis is the strain and the y axis is the stress. I need to draw the average line of all lines. the problem is, that the data alligned. I mean X values are not equal in each sheet. Example: the cell number 2000 has in a sheet X=3 in another one X=3,56 . That means i cant make an average vlaue column and put it in the chart.
    any help ?
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,712

    Re: Average Line

    How about adding another series?

    Which uses all data points from each series and plot trendline based on it.

    Edit: Found a good article on the subject. See link below.
    https://peltiertech.com/trendline-for-multiple-series/
    Last edited by CK76; 06-05-2019 at 10:03 AM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    06-05-2019
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    2

    Re: Average Line

    hi CK76,
    thx for your answer. I dont think i can make another series. I can give a simple example of the case. please check the attachement. the X values are not compatible with each other.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,712

    Re: Average Line

    Hmm? It doesn't matter if x has different values. They are all within chart range 0~4.5 no?

    If you need further help, I'd recommend uploading sample workbook.

    To upload, use "Go Advanced" button, and follow "Manage Attachments" hyperlink. It will open new tab/window to manage uploads.

    Edit:
    If you need to do something more mathematical... you'd first need to find polynomial trend line equation for each series.
    Then solve each for same x value, and average y values. Plot new series using averaged y value.
    Last edited by CK76; 06-05-2019 at 11:35 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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