+ Reply to Thread
Results 1 to 3 of 3

Plot a line from beginning to the end of a trip

  1. #1
    Forum Contributor
    Join Date
    07-22-2012
    Location
    Spain
    MS-Off Ver
    Excel 2008
    Posts
    304

    Plot a line from beginning to the end of a trip

    Hi,

    I have a chart which plots the loading quantity of a truck based on time and trip.

    I am now trying to plot a red line which joins the beginning of the trip till the end (before the next trip starts) but have no success.
    I have attached an example to explain a bit better myself.

    Any help would be much appreciated.

    Kind regards,
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Plot a line from beginning to the end of a trip

    timebased%20graph(1).xlsm

    Try this. Couldn't quite work out where you wanted to start the first line from though but after that it all seems to match up with your freedrawn lines (which I deleted)
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Contributor
    Join Date
    07-22-2012
    Location
    Spain
    MS-Off Ver
    Excel 2008
    Posts
    304

    Re: Plot a line from beginning to the end of a trip

    Hi Crooza,

    Thank you very much for your proposal, works perfectly like that!!

    Kind regards

+ 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. Converting Scatter plot to Line plot and back
    By SPDavern in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 10:49 AM
  2. Excel line plot combined with bar plot - advanced
    By zsmole in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-02-2014, 07:56 AM
  3. Replies: 3
    Last Post: 08-28-2012, 09:16 AM
  4. Line Graph - Do plot zero, Don't plot #NA
    By Janc in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-01-2012, 05:45 PM
  5. Converting XY Scatter plot to Line Plot and back
    By SPDavern in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2005, 10: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