+ Reply to Thread
Results 1 to 2 of 2

Create a running total - create a "pretty" report

  1. #1
    Registered User
    Join Date
    02-27-2017
    Location
    Pittsburgh, Pennsylvania
    MS-Off Ver
    2013
    Posts
    3

    Question Create a running total - create a "pretty" report

    I'm newer to using excel on a daily basis. I have to create a "pretty" report that will keep track of the amount of entries for a specific team as well as identify individual members and their participation in submitting entries. I have a report that is pulled that has a separate line for each entry received. I would like to "tally" the amount of times someone's name appears in the lines as well as create a graph that shows total number of entries received weekly which I can then hopefully compile to monthly/quarterly. What is the best way to track this information and also create a graph that shows overall summaries?

    TIA

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: Create a running total - create a "pretty" report

    Welcome to the Forum.

    In general, you will have to manipulate your data to produce a summary table, which you can then use as the source for your graph(s). However, I can't be more specific than that as you have not given many details about how your data is laid out - it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
    Please note that the Paperclip icon does not work.

    Hope this helps.

    Pete

+ 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: 10
    Last Post: 12-31-2014, 11:04 AM
  2. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. Replies: 12
    Last Post: 10-15-2012, 03:57 PM
  4. Need to create a report showing 3 day / 14day / 28day customer calls based on "last week"
    By TopherBrowne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2012, 10:30 AM
  5. Replies: 0
    Last Post: 02-14-2012, 12:31 PM
  6. Replies: 1
    Last Post: 02-07-2010, 12:44 AM
  7. [SOLVED] Linking two "total" pages to create a "Complete Total" page
    By Jordon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2006, 07:20 PM

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