+ Reply to Thread
Results 1 to 2 of 2

Line Chart with different time

  1. #1
    Registered User
    Join Date
    09-06-2009
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    2

    Line Chart with different time

    Hello:

    I have two data source which is record by date & time. However, I would like to create a single line chart to show these 2 data at the same chart. It is possible to do that?

    Source A
    Device Time Value
    Hit Rate A 8/2/2018 12:03 52
    Hit Rate A 8/2/2018 12:08 51
    Hit Rate A 8/2/2018 12:13 52
    Hit Rate A 8/2/2018 12:18 52


    Source B
    Device Time Value
    Hit Rate B 8/2/2018 12:02 52
    Hit Rate B 8/2/2018 12:06 52
    Hit Rate B 8/2/2018 12:09 51
    Hit Rate B 8/2/2018 12:12 51
    Hit Rate B 8/2/2018 12:14 52
    Hit Rate B 8/2/2018 12:19 51


    Thanks a lot!

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

    Re: Line Chart with different time

    Short but useless answer -- yes it is possible.

    I am not exactly sure how you are wanting to show these two data sets in the chart. Whatever you want, though, I would expect to start as an XY scatter chart.

    Here's a tutorial showing the basics of creating a scatter chart: https://www.excel-easy.com/examples/scatter-chart.html Create the scatter chart based on one of the data series, then bring up the select source data dialog (follow the link to the next page in the tutorial) to add the second data series.
    Because your X values are using dates/times, you will want to review something like this: https://www.excel-easy.com/examples/scatter-chart.html that explains how Excel stores and works with dates and times. Then, make sure your time stamps are real date/time serial numbers and not text strings.

    What do you have trouble with?
    Last edited by MrShorty; 08-18-2018 at 12:58 AM.
    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. Replies: 0
    Last Post: 01-29-2014, 08:10 PM
  2. [SOLVED] Time series line chart
    By Mroy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-08-2013, 06:56 AM
  3. Replies: 1
    Last Post: 12-31-2012, 05:31 AM
  4. date and time line chart
    By ilfan83 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-23-2012, 12:04 AM
  5. How to create a vertical reference line on a time series line chart
    By Bladebgii in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2012, 10:17 AM
  6. Time line chart
    By indyirlfan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-04-2012, 01:29 PM
  7. Time line chart
    By Confused in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 02:05 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