+ Reply to Thread
Results 1 to 4 of 4

Count fixed values in pivot and make pie chart

  1. #1
    Registered User
    Join Date
    07-18-2019
    Location
    Switzerland
    MS-Off Ver
    2016
    Posts
    12

    Count fixed values in pivot and make pie chart

    Hi everyone

    In the document attached I need the Pivot on "Sheet 2" to to count the Team members (USI/ECDR) in the "Team 1 (2)" Sheet. From the Pivot I need a pie chart that shows the percentage and absolute value of people in "USI/ECDR". Also the pivot and pie chart should update automatically if new people are added to the list. If possible it should also be possible to filter for active/inactive.
    Help would be much appreciated.
    Attached Files Attached Files
    Last edited by Asyra; 08-16-2019 at 05:24 AM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    R.D.C.
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    7,397

    Re: Count fixed values in pivot and make pie chart

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-18-2019
    Location
    Switzerland
    MS-Off Ver
    2016
    Posts
    12

    Re: Count fixed values in pivot and make pie chart

    Hi Pepe
    I just realised it didn't upload the mock file. Please find the sheet attached now.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,564

    Re: Count fixed values in pivot and make pie chart

    If I understand correctly the pivot table on Sheet2 will do what you want with the exception of automatically updating (I believe that will require VBA) which would need to be done by choosing Refresh from the Pivot Table Analyze tab.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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