+ Reply to Thread
Results 1 to 2 of 2

Time-travel timeline chart (with negative lines)

  1. #1
    Registered User
    Join Date
    01-14-2019
    Location
    Durham, UK
    MS-Off Ver
    Windows 10
    Posts
    3

    Time-travel timeline chart (with negative lines)

    I'm trying to produce a chart and I'm not sure it is possible in Excel. Can anyone please assist?

    For a project, I'm trying to map a 'Back to the Future' style time-travel story as a scatter-chart. I want to have the Year along the X axis and the 'event' coded by a number on the Y axis - so a point on the chart might mean, say, 'Paris in 1980'. As characters travel forwards and backwards in time, the line should go forwards and backwards on the X axis while they reach different 'events' in various Y positions. I have several characters whose worldlines are different and need to be visible, in contrast to time and each other, so essentially I'm looking for:

    1) a way of plotting 'events'
    2) a way of joining them with lines in different ways for different characters.

    I've attached a mock-up of what I mean, with two paths in different colours (sorry it looks so mince: arrows and order numbers are just for show; and the axis numbers don't quite line up). Is this possible to achieve with Excel? If not, is there alternative software that will do this from an Excel dataset?

    Thanks for your help.
    Graph.png

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

    Re: Time-travel timeline chart (with negative lines)

    Not sure what you have tried, but it looks like a basic XY scatter chart. In a scatter chart, Excel will connect points in the order they are arranged in the spreadsheet. If you are unfamiliar with creating scatter charts in Excel: https://www.excel-easy.com/examples/scatter-plot.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Counting a travel day as half if travel starts before specific time
    By akesupport in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2018, 10:37 AM
  2. Estimated Travel Time
    By ctexcelguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-13-2013, 01:03 AM
  3. Calculating travel time for set destinations
    By ashcrroft752 in forum Excel General
    Replies: 4
    Last Post: 06-14-2012, 08:06 PM
  4. Function to get travel time from mapquest
    By sunnyk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2010, 10:05 PM
  5. Time Travel & Upon Opening WB Macros
    By gandolff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2009, 11:47 AM
  6. time formula with fixed travel time
    By loudguy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-02-2009, 06:33 AM
  7. travel time distance formula
    By kapanenship in forum Excel General
    Replies: 2
    Last Post: 05-20-2008, 12:35 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