+ Reply to Thread
Results 1 to 3 of 3

Can't get a good graph

  1. #1
    Registered User
    Join Date
    02-25-2012
    Location
    Norway
    MS-Off Ver
    MS365 v.2202
    Posts
    37

    Can't get a good graph

    Hi, I'm trying to get viewable statistic from something at work. We do something that last hours:minutes, each time we do this we write down the time it takes.
    Now I try to make a graph of it but only get a stright line. I kinda want something that group 3:55 ~ 3:58 because they are so similar. And we need more paperwork if the time exceed 4:00 and a few years ago you can see that it often just took 3:55-4:00. I want to show this with the graph. Maybe a upward dent in that time span.

    It's hard to explain want I want but the standard graphs only give me one line/dot for each seperate time.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Can't get a good graph

    Take a look at your modified workbook.

    It needed X-axis names. I only charted the data where you had complete info(to line 76).

    There are a couple abnormal data points(you will see the spike.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-25-2012
    Location
    Norway
    MS-Off Ver
    MS365 v.2202
    Posts
    37

    Re: Can't get a good graph

    Thanks for the reply but it doesnt really show much. It plot(?) the chart as it's entered in excel. If I sort the column it will just give me an increasing line.

    I made a simple picture in paint to show what I'm hoping to create.
    Attached Images Attached Images

+ 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