+ Reply to Thread
Results 1 to 2 of 2

Thread: need advice to make the right chart

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    Moscow, Russia
    MS-Off Ver
    office for mac 2011
    Posts
    1

    need advice to make the right chart

    I have such kind of data in table:

    Logging_Time Originator
    12:30:00 20163
    12:30:00 20160
    12:30:00 20160
    12:30:00 20161
    12:30:00 20161
    12:30:00 20161
    12:30:00 20160
    12:30:00 20163
    12:30:00 20160
    ....
    12:30:03 20162
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 20162
    12:30:03 20163
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 199
    12:30:03 20163
    12:30:03 20162
    12:30:03 20160
    ...

    and I want to make something like this:

    time should be used for X-axis, Y-axis should be a line chart, counting number of occurrences of same number during same time. Like:

    199
    199
    20163
    20163 199
    20163 20161
    20160 20161
    20160 20160
    20160 20160
    --------------------------
    12:30:00 12:30:01

    so I need to get how many different events happening each second in sum and also separately

    cannot decide how to start...

  2. #2
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,520

    Re: need advice to make the right chart

    Looks like a job for a Pivot Table/Chart.
    Group on the Time Values and count the occurrences of each time.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

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