Results 1 to 7 of 7

HOw to plot a line graph to show Speed vs Time of Day

Threaded View

  1. 08-20-2016, 11:52 PM #1
    nsmjc
    nsmjc is offline
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    100

    HOw to plot a line graph to show Speed vs Time of Day

    Attached is a day of data I Have to identify a speed issue. I need to present this in a chart format indicating the MPH at the different times during the Day. I need to do this for each day during the span of a week the data attached is for one day.

    I have tried various way of doing this all and proven to be incorrect.

    The time is every 15 minutes
    The Speed is across the top in yellow
    the numbers in the field represent how many vehicles traveled at that point in time and at the speed.

    Any help would be gratefully appreciated.
    Attached Files Attached Files
    Last edited by nsmjc; 08-28-2016 at 12:02 AM. Reason: Solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Making one line graph with two different time interval data from 2 plot
    By sohel_for in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2016, 11:10 PM
  2. [SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?
    By nscarritt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  3. [SOLVED] How do you plot real time data into a line graph?
    By jonathan@ibbotsons in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-30-2013, 09:49 AM
  4. Create a line graph to represent Speed
    By doucie1 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-11-2012, 09:43 AM
  5. 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
  6. [SOLVED] how do I plot a constant value in a line graph?
    By Debby Blaine in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-11-2006, 04:15 AM
  7. Scatter plot and line graph combination
    By Tim Gilderseeve in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2005, 03:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1