+ Reply to Thread
Results 1 to 2 of 2

Can you help on a graph ?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    Charleroi, Belgium
    MS-Off Ver
    Excel 2003
    Posts
    1

    Can you help on a graph ?

    Hi All,

    I have a sheet composed by the following columns :

    YEAR MONTH DAY HOUR MINUTE
    2010 02 15 14 58
    2010 02 15 14 57
    2010 02 15 14 54
    2010 02 15 14 54
    2010 02 15 14 46
    2010 02 15 14 46
    2010 02 15 07 21
    2010 02 15 06 47
    2010 02 15 06 47
    2010 02 15 06 41
    2010 02 15 06 12
    2010 02 15 06 10
    2010 02 11 14 46
    2010 02 11 14 45
    2010 02 11 14 45
    2010 02 11 14 45
    2010 02 11 14 44
    2010 02 08 21 09
    2010 02 08 21 09
    2010 02 08 21 08
    2010 02 08 21 08
    2010 02 08 21 07
    2010 02 08 20 04

    This corresponds to incidents that are logged in a table for an application. anyway, this is just to give you the context.

    Now I would like to setup a graph which have as X axis the days of february, and as Y, a value 1 when for each date+time in my columns, and a 0 when no date+time is in my columns.

    Can you help on this ?

    Thanks by advance.
    Vincent.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,637

    Re: Can you help on a graph ?

    You can write in next column =SIGN(A1) and then select A and B column -> Scatter graph

+ 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