+ Reply to Thread
Results 1 to 3 of 3

Time Scale Charts

  1. #1
    Registered User
    Join Date
    02-08-2005
    Posts
    38

    Time Scale Charts

    Hi is there a way to create a time scale chart measured in hours and minutes.
    Help says only months and days but thought there might be a way around it

    Thanks

  2. #2
    Registered User
    Join Date
    12-30-2008
    Location
    Vermont, USA
    MS-Off Ver
    Excel 2003
    Posts
    64
    I might be misunderstanding your question, but if you simply want a chart with time in hours:minutes as the x-axis, that's not a problem. In fact, you should be able to use whatever you like for the x-axis by designating that column as the source data for the x-axis labels in the chart wizard. If you wanted your x-axis origin to be 0:00 and go up in multiples of 5 minutes, you would put this in your first cell next to your y-axis data:

    0:00
    this in your next:
    0:05
    then fill down as far as you need. The x-axis will then be 0:00 0:05 0:10 0:15...

    Is that what you're looking for?

  3. #3
    Registered User
    Join Date
    02-08-2005
    Posts
    38
    Hi many thanks now sorted

+ Reply to Thread

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.6.0 RC 1