+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    64

    Time line chart of cumulative count

    Hello,

    My data is as follows

    username | date created
    a | 04/03/2009 15:34:58
    b | 12/03/2009 10:51
    c | 20/03/2009 20:39
    d | 04/03/2009 15:34


    not sorted by date created. I am after a chart that shows the cumulative number of new users per week. Using 2007 so used the weeknum function giving me the number of new users per week. I pull this in a pivot table, so I get a count of users per week I can show in a line graph. So far so good. Now I need to display the cumulative number (so, total of users over time)... grateful for your help.
    Last edited by deemo; 06-04-2009 at 11:57 AM.

  2. #2
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    64

    Re: Time line chart of cumulative count

    Found the solution... must have been asleep. Changed pivot field to count, show value as running total. Done!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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