+ Reply to Thread
Results 1 to 3 of 3

Graph Help Please

  1. #1
    Registered User
    Join Date
    03-08-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    11

    Graph Help Please

    Hi

    This should be easy but I just cant see it (to many Mince pies maybe)

    I have an xls that has Date, User ID and Count and I want to plot a line for each user for each date with the count - so dates at the bottom and a line per user across the month

    xls attached pointers really appreciated

    John B
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,538

    Re: Graph Help Please

    By altering the data layout (see new table in attached) it's possible to chart what I think you mean.

    You could probably do this with Pivot Charts too.

    BSB
    Attached Files Attached Files
    Please show appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,538

    Re: Graph Help Please

    Here's a version doing the same but with a Pivot Chart.
    It gives you the added ability to easily drill down to see individual users.

    BSB
    Attached Files Attached Files

+ 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