+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    05-08-2009
    Location
    New Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    14

    Create Plot with time

    I have a column of time in the h:mm:ss format. If I click on one of these cells, the workling window displays the time plus a "PM" or "AM"
    e.g.
    cell: 13:12:30
    working window: 1:12:30 PM

    All good so far....

    When I plot time on Xaxis and respective data on the Yaxis I get 0-X numbers (1,2,3 etc...) onthe Xaxis.

    I am trying to get the time on the x-Axis, e.g. 13:12:30...

    I have tried formating the X-axis to h:mm:ss, the only choice was h:mm:ss; @

    I've tried the time formats without any luck also...

    Thanks,
    Dave

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Create Plot with time

    Hi Dave,

    can you post a sample file with some of your data and the chart you made?
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

Thread Information

Users Browsing this Thread

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

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.2.0