+ Reply to Thread
Results 1 to 4 of 4

Graph date + time

  1. #1
    Registered User
    Join Date
    08-20-2020
    Location
    Apeldoorn, The Netherlands
    MS-Off Ver
    MS Office 365
    Posts
    20

    Graph date + time

    Hi all,

    I made a graph (see appendix) with many data points. I would like to show both the date and the time on the X axis. However, I would like to show each date once, below the time in the graph. I can't find a solution to do this. Any suggestions?

    Thanks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Graph date + time

    Added date and time. See the attached.
    Is this one you are looking for?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-20-2020
    Location
    Apeldoorn, The Netherlands
    MS-Off Ver
    MS Office 365
    Posts
    20

    Re: Graph date + time

    Thanks! This would be a solution indeed. However, I would like (if possible) to show each date just once in the graph, for example below the times of the particular date. So a more overlapping date. Do you know whether this is possible? I think it would give a better view, since there are so many data points.
    If this is not possible, maybe a line between each date of a different color would give a better views. Do you know whether this is possible?

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

    Re: Graph date + time

    I am optimistic that most things are possible, but it may not involve built in options.

    I notice that Shareez Saleem used a line chart with a text/category axis. If I were to do this, I would use an XY scatter chart. If I did not like Excel's default divisions on the x axis, I would format the axis to have 1 for the major unit and 0.25 (6 hours) for the minor unit and format the axis labels to show only day.
    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. Trying to create a date and time graph
    By jonnegri in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-18-2018, 11:14 AM
  2. [SOLVED] Cannot get Excel to properly format a date time graph
    By filky in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-03-2017, 11:43 AM
  3. Time/Date Graph
    By SeanKosmann in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-11-2015, 10:46 AM
  4. Time and date graph
    By acoron01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-21-2014, 03:59 PM
  5. graph axes (time and date)
    By talkative__ in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-16-2013, 05:58 AM
  6. Time Date and Graph help (complex formula)
    By mrbadss in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-21-2009, 07:54 AM
  7. using date & time in the x axis of a graph
    By sjhonny in forum Excel General
    Replies: 2
    Last Post: 01-18-2007, 09:39 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