+ Reply to Thread
Results 1 to 4 of 4

Plot the difference between two values over time

  1. #1
    Registered User
    Join Date
    06-07-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    14

    Plot the difference between two values over time

    Hi,

    We have various machines with screws and barrels. Over time, the screws wear against the barrels, so the screws get smaller and the barrels get bigger and so the gap between them gets bigger.

    I've attached a log of one of the machines, where I've input the data at the date the measurement was taken, then subtracted one from the other to give the gap between the screw and barrel.

    I want a nice visual way of displaying on a graph this increasing graph trend. How is the best way to do it? I can't get my head around it.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,289

    Re: Plot the difference between two values over time

    It's not clear to me how you want to show the data. Going for the low hanging fruit, I:

    1) Selelct B2:D2 ctrl B5:D5 ctrl B8:D8 and so on so that I have a multi-range selection that includes just the "gap" rows.
    2) Insert -> chart -> line chart

    I end up with a line chart with dates on the horizontal axis and gap on the vertical axis, and multiple lines/data series for each zone. As a first guess, what do you think?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    06-07-2019
    Location
    UK
    MS-Off Ver
    2016
    Posts
    14
    Quote Originally Posted by MrShorty View Post
    It's not clear to me how you want to show the data. Going for the low hanging fruit, I:

    1) Selelct B2:D2 ctrl B5:D5 ctrl B8:D8 and so on so that I have a multi-range selection that includes just the "gap" rows.
    2) Insert -> chart -> line chart

    I end up with a line chart with dates on the horizontal axis and gap on the vertical axis, and multiple lines/data series for each zone. As a first guess, what do you think?


    Thanks for the reply, I was hoping to have the screw and barrel logged on the same graph, with the gap shown between them, shaded in. That way, I can see visually where the cause of the gap is coming from, screw or barrel

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,289

    Re: Plot the difference between two values over time

    That sounds like you want a stacked area chart. I expect it will be very hard to read more than one screw/barrel pair on a chart (unless you intend to use filters to display only one pair at a time).

    1) Select the date and screw and gap rows for one pair. For zone 2 left, for example, select B2:D2 ctrl B6:D6 ctrl B8:D8.
    2) Insert a stacked area chart. If Excel opts to "plot data series by columns", execute "switch row/column".
    3) Format the chart elements as desired (Axis minimum set to 130 or similar if Excel defaults to 0. Format the "screw" data series to have no fill color in order to highlight the gap series, and any other formatting you want).

    If that does what you want for a single screw/barrel pair, then you can repeat the process for each pair and have a chart for each pair. Or we can use lookup or filter tools to extract the data for a single pair into a helper range and use that helper range for the chart. It all depends on how you intend to interact with this data in the spreadsheet.

+ 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] Time difference between two date/time values which are in the format DD-MM-YYY HH:MM
    By snkhan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2020, 10:31 AM
  2. [SOLVED] Get the difference between two time values
    By RASIKA_99 in forum Excel General
    Replies: 2
    Last Post: 10-07-2019, 12:25 AM
  3. [SOLVED] Time Values Difference
    By Firepxy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2013, 02:09 AM
  4. difference in milliseconds between time values
    By aocana in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-11-2013, 05:23 AM
  5. difference in milliseconds between time values
    By bigbillis in forum Excel General
    Replies: 3
    Last Post: 12-30-2010, 01:34 PM
  6. [SOLVED] Calculating Absolute Difference Between Two Time Values
    By markxus in forum Tips and Tutorials
    Replies: 3
    Last Post: 08-10-2005, 01:43 AM
  7. Replies: 1
    Last Post: 03-25-2005, 01:06 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