+ Reply to Thread
Results 1 to 2 of 2

% of Target Met Doughnut Chart

  1. #1
    Forum Contributor
    Join Date
    08-13-2009
    Location
    Caribbean
    MS-Off Ver
    Excel 2003
    Posts
    129

    % of Target Met Doughnut Chart

    Hello,

    My experience with charts is only at basic level and im sure what I want to achieve is not that difficult. However, I am trying to create a dashboard type representation of data in excel and need to include a few of these "charts".

    So basically, I am comparing a YTD figure vs the budgeted figure for the year. And what I want to do is show this visually in a doughnut chart... the full circle representing the total target for the year, and a separate highlighted area showing what we have achieved TYD.

    Thanks and I will probably be back with a few more questions as this progresses. I would also be willing to share with the forum here once I am done although I am sure it won't blow too many people away

    Cheers

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: % of Target Met Doughnut Chart

    I've done a couple of examples on the attached workbook.

    One uses a single ring donut to show progress to date, the other has two rings, the outer showing the total for the year and the inner showing the amount to date and the amount left.

    There are all sorts of other ways of showing this kind of data by merging different chart types to create "guage" style charts. chandoo.org has some good ones or ask again here.
    Attached Files Attached Files
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

+ 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. Doughnut Pie chart
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2016, 04:23 PM
  2. Doughnut Pie chart- v lookup
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2016, 01:00 PM
  3. Doughnut Chart Labels
    By Shleifer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-24-2014, 04:02 AM
  4. Doughnut-pie combine chart
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-26-2014, 07:49 AM
  5. Doughnut chart 2 rings help
    By jmoslund in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2011, 06:55 AM
  6. Doughnut chart
    By TomBP in forum Access Tables & Databases
    Replies: 8
    Last Post: 02-19-2011, 09:46 AM
  7. Label Doughnut-Chart outside
    By Steeplechase in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-02-2006, 05:25 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