+ Reply to Thread
Results 1 to 4 of 4

Need help creating a vehicle tracking log chart

  1. #1
    Forum Contributor
    Join Date
    09-28-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    102

    Need help creating a vehicle tracking log chart

    I'm trying to chart the daily usage of vehicles, this is an example of the current data set I'm working with

    Vehicle Route Start Location Start Time End Time End Location
    001 A X 10:00 10:30 Y
    001 A Y 10:45 11:15 X
    002 A Y 10:15 10:45 X
    002 A X 11:00 11:30 Y
    003 B X 10:00 10:45 Z
    003 B Z 11:00 11:45 X

    I would like to plot a chart where the bottom axis is time and the side axis is the vehicle number, with a bar running from the start time to the stop time.

    Inside the bar, ideally, I would like 3 labels.

    Start time at the beginning, service in the middle, and end time t the end.

    Like this (based on above data):
    Please Login or Register  to view this content.
    Thanks in advance...

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Need help creating a vehicle tracking log chart

    You could maybe just use a regular bar chart, turned on its side?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    09-28-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    102

    Re: Need help creating a vehicle tracking log chart

    But how do you get the bars to float and stack on the same column?

  4. #4
    Forum Contributor
    Join Date
    09-28-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    102

    Re: Need help creating a vehicle tracking log chart

    OK, so I managed to get the bars laid out how I wanted by using a Gantt chart and following a couple of tutorials I have come up with the following:

    2017-06-11 (1).png

    Now all I need to do is work out how to label the bars...

    Tutorials used:
    Step-by-Step Instructions for Making a Gantt Chart in Excel
    Easier Gantt Chart for Repeated Tasks
    Attached Images Attached Images
    Last edited by escribblings; 06-11-2017 at 04:02 PM.

+ 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. Index vehicle, driver and vehicle wise revenue report.
    By dackson in forum Excel Formulas & Functions
    Replies: 41
    Last Post: 06-02-2017, 01:40 AM
  2. Vehicle mileage tracking Spreadsheet formula help
    By mhenders00 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-07-2016, 12:51 AM
  3. Need chart to display vehicle age information
    By pnelsonmi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2013, 02:41 PM
  4. Replies: 2
    Last Post: 01-30-2013, 12:06 PM
  5. Creating a report to show Vehicle Tax Due.
    By james118 in forum Excel General
    Replies: 4
    Last Post: 04-02-2012, 03:57 PM
  6. Setting up a fleet vehicle mileage tracking sheet
    By gcoug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2011, 12:09 PM
  7. [SOLVED] help in creating charts of vehicle data
    By TM in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-16-2005, 12:06 AM

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