+ Reply to Thread
Results 1 to 2 of 2

Chart only ONE task as percentage of ALL tasks? PLEASE HELP!

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Burnaby, BC
    MS-Off Ver
    Excel 2010
    Posts
    29

    Chart only ONE task as percentage of ALL tasks? PLEASE HELP!

    Example.JPG

    Hi Everyone:

    I've attached an image of a pivot table showing the percentage of various tasks that employees have done out of 100% of their tasks. What I need to do is create a pivot table focused only on the STB tasks. It's a catch 22 - I need all of the other tasks in order to establish what 100% of the tasks are, but I only want to represent one specific task. How can I chart just one of the tasks as a percentage of all the tasks?

    Thanks for your help!

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Chart only ONE task as percentage of ALL tasks? PLEASE HELP!

    Hi,

    Right click on the Pivot Table,
    Select "Pivot Table Options",
    Go to 'Display' tab
    Select - 'Classic Pivot Table Layout' tick mark

    This would move the items listed under the main headers to a new column and you would be able to chose the drop down you want.

    Regards,
    Chandra

+ 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. [SOLVED] Creating Chart of Percentage complete for task
    By GAC1234 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-22-2015, 06:47 AM
  2. Workout overall percentage of completed tasks
    By aamarb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2013, 08:30 AM
  3. Task Planner - read out list of tasks for different employees
    By Jilseponie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2013, 09:11 AM
  4. Replies: 2
    Last Post: 11-02-2011, 12:49 PM
  5. Replies: 1
    Last Post: 08-29-2006, 07:21 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