+ 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
    41

    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, UK
    MS-Off Ver
    365
    Posts
    7,468

    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

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    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)

Similar Threads

  1. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  2. Replies: 0
    Last Post: 10-03-2014, 07:51 AM
  3. Replies: 0
    Last Post: 09-15-2014, 02:01 AM
  4. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  5. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  6. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  7. Hyperlinkage of one graph with another graph or Drill down graph
    By Sanjay Kumar Singh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 08:25 AM

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