+ Reply to Thread
Results 1 to 3 of 3

Displaying start time and duration (both in seconds) on X-axis and values on Y-axis

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    Galway, Ireland
    MS-Off Ver
    office 2010
    Posts
    2

    Displaying start time and duration (both in seconds) on X-axis and values on Y-axis

    hi,

    I would like to display data with start time, a duration and value
    on a chart with start time and duration on the X-axis and value on Y-Axis.
    Start time and duration are both in seconds.
    The value is constant for the entire duration.

    Sample data may look like:
    Start Duration Value
    1.276750001 0.66 66.16876984
    17.73675 0.38 11.20071316
    28.71675 0.88 15.45351791
    31.55675 0.97 11.51876259


    Please see attachment for crude visualisation of desired plot.

    Is this possible using excel?
    Apologies if this is trivial - I cant see a way to do it.

    Regards,
    Ciaran
    Attached Images Attached Images

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Displaying start time and duration (both in seconds) on X-axis and values on Y-axis

    Yeah:
    Scatterplot with Start as X-axis and Value as Y-axis
    Then enable error bars
    Use the Duration range as the +X Errors
    Set Y error bars as zero

    Then for formatting, no series or line marker,
    And I increased the weight of the error bar and gave it a color.

    See attached.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    12-15-2015
    Location
    Galway, Ireland
    MS-Off Ver
    office 2010
    Posts
    2

    Re: Displaying start time and duration (both in seconds) on X-axis and values on Y-axis

    Cheers, thanks very much for the detailed response.

+ 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. Pri & Sec Axis to Start from Horizontal Axis at 0
    By Apple1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-14-2015, 10:54 PM
  2. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  3. Replies: 2
    Last Post: 11-02-2012, 05:21 AM
  4. [SOLVED] Y-Axis Displaying Wrong Values for Data Series! Help!
    By smadey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-01-2012, 10:12 AM
  5. Displaying time and date on x axis of scatter plot
    By AJMaine in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-14-2009, 06:35 AM
  6. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  7. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1