+ Reply to Thread
Results 1 to 2 of 2

Donut pivot chart to show completed work and work left

  1. #1
    Registered User
    Join Date
    06-10-2020
    Location
    New York, NY
    MS-Off Ver
    MS Office 2016
    Posts
    34

    Donut pivot chart to show completed work and work left

    Hi,

    I have a pivot table with three columns: Job Name, % Completed, and % Left. I want to create a donut chart to show the percent completed and percent left for each of the jobs when I click on the job's respective name in a slicer. For example, JobXYZ is 60% completed and 40% left. I want a single donut to show up when I click on JobXYZ in the slicer and 60% of the donut be red and 40% of the donut be blue.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,641

    Re: Donut pivot chart to show completed work and work left

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. Donut Chart with 2 data sets - Legend does not work
    By jasonj427 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2015, 04:56 AM
  2. [SOLVED] I need If Completed then 100%, If In Work then 50%, If Not Started then 0%
    By cllmetatrsld in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-16-2014, 12:25 PM
  3. [SOLVED] Breakdown of staff work completed
    By jaywizz in forum Excel General
    Replies: 5
    Last Post: 04-04-2014, 05:19 PM
  4. Replies: 5
    Last Post: 01-31-2013, 12:08 PM
  5. Creating a chart, can't get a pivot table to work.
    By arcing in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2013, 08:40 AM
  6. Formula to calculate the percentage of work completed
    By Zodiark in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2012, 04:42 PM
  7. Creating an updated work completed sheet?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2006, 02: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