Results 1 to 2 of 2

Thread: Help with graphs

  1. #1

    Help with graphs



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi..

    Im hoping someone can help me with some help building a graph.

    I have a spreadsheet which I have simplified down to two columns, one is date, and the other is a number between 1 and 10.

    The number between 1-10 signifies a category of a particular event that happened that day. Some dates have more than one event.

    I would like to graph the total number of occurrences of each category over a monthly period.

    So, maybe a line graph with 10 lines, and then the amount of instances for that month on the Y axis or something like that? I would also settle for 10 individual graphs if that was my only option. I am somewhat a novice when it comes to excel - I would really appreciate if someone could help me.

    A sample of the data is as follows.

    Thanks.


    DATE EVENT CATEGORY
    25/04/15 2
    25/04/15 1
    25/04/15 4
    25/04/15 2
    25/04/15 1
    27/04/15 1
    27/04/15 4
    28/04/15 5
    29/04/15 1
    30/04/15 2
    30/04/15 1
    1/05/15 5
    1/05/15 5
    1/05/15 5
    1/05/15 5
    1/05/15 10
    2/05/15 7
    2/05/15 4
    3/05/15 2
    5/05/15 5
    6/05/15 7
    7/05/15 5
    7/05/15 1
    9/05/15 3
    10/05/15 1
    12/05/15 7
    12/05/15 2
    12/05/15 1
    13/05/15 1
    14/05/15 1
    15/05/15 7
    16/05/15 1
    16/05/15 1
    17/05/15 1
    17/05/15 7
    17/05/15 1
    17/05/15 2
    18/05/15 5
    18/05/15 5
    18/05/15 5
    18/05/15 3
    18/05/15 1
    20/05/15 1
    20/05/15 1
    21/05/15 7
    21/05/15 4
    22/05/15 2
    22/05/15 1
    25/05/15 4
    25/05/15 7
    25/05/15 7
    25/05/15 3
    26/05/15 5
    26/05/15 3
    27/05/15 5
    28/05/15 1
    29/05/15 7
    30/05/15 5
    30/05/15 1
    1/06/15 1
    1/06/15 10
    1/06/15 4
    1/06/15 7
    2/06/15 5
    2/06/15 10
    2/06/15 2
    2/06/15 5
    2/06/15 4
    2/06/15 1
    3/06/15 1
    3/06/15 1
    5/06/15 7
    5/06/15 1
    5/06/15 1
    5/06/15 5
    6/06/15 8
    6/06/15 6
    7/06/15 1
    7/06/15 1
    8/06/15 1
    8/06/15 4
    9/06/15 7
    10/06/15 4
    10/06/15 1
    11/06/15 2
    12/06/15 2
    13/06/15 7
    13/06/15 1
    13/06/15 4
    14/06/15 7
    15/06/15 1
    16/06/15 1
    16/06/15 1
    16/06/15 3
    16/06/15 1
    16/06/15 5
    17/06/15 7
    17/06/15 7
    17/06/15 2
    18/06/15 10
    18/06/15 8
    18/06/15 5
    19/06/15 5
    19/06/15 1
    19/06/15 6
    19/06/15 7
    20/06/15 6
    22/06/15 6
    22/06/15 7
    25/06/15 10
    26/06/15 2
    27/06/15 1
    27/06/15 1
    27/06/15 4
    27/06/15 4
    28/06/15 7
    29/06/15 7
    30/06/15 1
    30/06/15 1
    30/06/15 1
    30/06/15 1
    1/07/15 5
    2/07/15 10
    2/07/15 6
    2/07/15 1
    3/07/15 1
    5/07/15 5
    5/07/15 1
    5/07/15 1
    6/07/15 1
    7/07/15 1
    8/07/15 1
    9/07/15 1
    9/07/15 1
    9/07/15 7
    10/07/15 3
    10/07/15 1
    10/07/15 9
    10/07/15 8
    11/07/15 3
    11/07/15 10
    12/07/15 7
    12/07/15 5
    12/07/15 5
    12/07/15 1
    12/07/15 3
    13/07/15 3
    13/07/15 1
    13/07/15 7
    14/07/15 1
    14/07/15 3
    14/07/15 5
    14/07/15 2
    15/07/15 7
    15/07/15 1
    15/07/15 5

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    114
    Articles
    0
    Excel Version
    365
    Hi,

    It simple by using PivotTable.
    Into your PT group the dates by month than count the number of each category.
    See attached file

    Good luck
    ForOzbroady.xlsx

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •