+ Reply to Thread
Results 1 to 2 of 2

Graph does not plot all values, horisontal axis have dates with multiple time points

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    Aarhus, Denmark
    MS-Off Ver
    2010
    Posts
    8

    Graph does not plot all values, horisontal axis have dates with multiple time points

    Hi all,

    I am trying to make a graph for two data sets. The sets are logs of temperature and relative humidity, measured every 15 minutes for two weeks.
    I have problems with the graph, when I do not select the yyyy-mm-dd hh-mm-ss as the horisontal axis, it shows all data points. However, when I want to show the dates and times on the horisontal axis, it only displays one value for each date, thus not the entire data set for every day.

    Has anyone encountered this problem before and know how to solve it?

    Cheers,
    Amalie

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Graph does not plot all values, horisontal axis have dates with multiple time points

    You need to use xy-scatter chart as line charts only have day accuracy when scale is Date.
    Cheers
    Andy
    www.andypope.info

+ 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. How to plot a comparison of only 3 points against 9 in graph
    By karryan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-28-2014, 04:04 AM
  2. Replies: 2
    Last Post: 07-24-2013, 11:42 AM
  3. [SOLVED] Plot two series ordered by different dates in the same graph, on the same x-axis.
    By droppe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-14-2013, 07:14 AM
  4. [SOLVED] Dynamic Graph, Do Not Want X-Axis to Plot Blank or Zero Values
    By TEBrown in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-11-2013, 05:08 AM
  5. adding data points with different x-axis values to a graph
    By st!ngray in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-19-2012, 09:22 AM

Tags for this Thread

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