+ 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
    Office 365 ProPlus
    Posts
    5,377

    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
    Office 365 ProPlus
    Posts
    5,377

    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)

Similar Threads

  1. [SOLVED] Average Every Second Line of an Array
    By Bronson84 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-24-2014, 03:44 PM
  2. Average Line
    By AsponeBR in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2012, 04:46 PM
  3. Add Average Line to chart
    By djblois1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-23-2010, 06:36 AM
  4. Straight Average Line on Line Chart
    By miked79 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-11-2008, 12:00 PM
  5. How to add an average line to a bar chart?
    By Dmitry in forum Excel General
    Replies: 5
    Last Post: 04-27-2006, 04:40 AM
  6. [SOLVED] How to add an average line to a bar chart?
    By Dmitry in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-27-2006, 04:40 AM
  7. Add an Average Line in a Scattergram
    By colbyatwood in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-29-2005, 02:05 PM

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