+ Reply to Thread
Results 1 to 4 of 4

Pivot Table not summarizing all data from pivot chart

  1. #1
    Registered User
    Join Date
    08-10-2016
    Location
    US
    MS-Off Ver
    365
    Posts
    70

    Pivot Table not summarizing all data from pivot chart

    Good Morning,

    I have a spreadsheet that tracks time spent on various categories. There are 3 sheets:

    1. Time Tracker: This is where employees will document their time including, day of the week, start time, end time, category & duration (Hours)
    2. Calculations: This is where the duration for each activity & day will be summarized into a table separated by Months
    3. Pivot: This is where the supervisor will be able to view how much time an employee has spent on various categories based on the selected days.

    The issue is that, when multiple dates are selected or placed into the Values field, the pivot table is not updating to reflect all selected fields. How can this be fixed?

    I apologize for any missing information as I have not posted here for a while. Please let me know if you have questions.

    I have included a spreadsheet for reference.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Pivot Table not summarizing all data from pivot chart

    Each column is treated as a series in a chart. With a pie chart only the first series will be displayed.
    If you change the chart type to bar you will see both days, although they will not be combined.

    You will have to combine the dates either with Calculated Items or in the source data.
    I think your issue will be you probably don't want a total for the month but rather a combination of any given days. In which case you would have to use a standard chart which plots the column total of the pivot table.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-10-2016
    Location
    US
    MS-Off Ver
    365
    Posts
    70

    Re: Pivot Table not summarizing all data from pivot chart

    Thank you so much for this explanation! I added totals for each week in the source data. Now the pie chart can be summarized by specific days, weeks or month total. However as you stated, it will not be able to select multiple days.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Pivot Table not summarizing all data from pivot chart

    If you based your pivots on the source data, rather than calculated data you could combine dates.

    Put Date in the Filter field and allow Multi selection.

    You could add a Month field to the Time Tracker data set, which could also be added to the Filter field.

+ 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. How to get an auto populating table summarizing pivot data?
    By Meggo12 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-08-2016, 08:50 AM
  2. Replies: 3
    Last Post: 03-24-2016, 01:49 PM
  3. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  4. Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  5. Summarizing Data with Pivot Table
    By karaf in forum Excel General
    Replies: 1
    Last Post: 01-24-2011, 09:25 PM
  6. summarizing data without a pivot table?
    By txbullets in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2008, 11:05 AM
  7. [SOLVED] organize data in a pivot table without summarizing?
    By pivot table help in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-01-2005, 09:40 PM

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.6.0 RC 1