+ Reply to Thread
Results 1 to 4 of 4

Excel data plotting

  1. #1
    Registered User
    Join Date
    06-29-2020
    Location
    united arab emirates
    MS-Off Ver
    2013
    Posts
    2

    Post Excel data plotting

    I have an excel file with 3500 points. I need to plot a graph taking the average of every 100th point, so as to get a clear curve. it is a flux vs time curve.
    so, the first point will be at 0s,0, then 100 s, ( and the average of first 100 flux values) then 200s, value of next 100 flux values and so on.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,163

    Re: Excel data plotting

    An attachment would make life easier as per the yellow banner, but would you plot as you describe? would 100s not be the average from 50-150 seconds?

    The averageif formula will do what you want, but without data is hard to write a formula for you

  3. #3
    Registered User
    Join Date
    06-29-2020
    Location
    united arab emirates
    MS-Off Ver
    2013
    Posts
    2

    Re: Excel data plotting

    Hi, thanks for your reply.
    I have attached the file.
    As you can see, there are too many data points. we need to plot a curve taking the average of every 100 points.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,163

    Re: Excel data plotting

    I would put
    =AVERAGE(OFFSET(A$2,(ROW(A1)-1)*100,0,100,1))

    as a formula and copy to the right one column and then down

    it averages each group of 100 points, these can then be plotted as a scatter graph, although I am not sure it is a curve

+ 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. Plotting Buy and Sell Data on Candlestick Chart in Excel
    By canikhil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-27-2018, 10:00 AM
  2. Excel Data Filtering and Plotting by User Input
    By ygzsmsk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2018, 04:47 AM
  3. Replies: 0
    Last Post: 07-28-2014, 05:49 PM
  4. Plotting Data in Excel (URGENT)
    By balshersidhu in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-26-2014, 02:27 PM
  5. Software for FAST plotting charts from dynamic excel data?
    By naira in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-26-2012, 01:48 PM
  6. Can I plot an equation in Excel instead of plotting data?
    By raechickx in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-21-2005, 07:05 PM
  7. [SOLVED] Plotting data in Excel
    By Dave Mac in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-15-2005, 12:06 AM

Tags for this Thread

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