+ Reply to Thread
Results 1 to 3 of 3

Static individual pie chart areas

  1. #1
    Registered User
    Join Date
    09-07-2009
    Location
    Lytham, England
    MS-Off Ver
    Excel 2003+07
    Posts
    75

    Static individual pie chart areas

    Hi,

    I'm trying to do a graph to represent percentage of doubles hit for a darts player.

    I know the best way to show this is probably a sorted horizontal bar chart but was after something visually impresive all be it not being powerful at all.

    I have attached a basic pie chart. What i want it to do is if the player has only has hit say 33% of his doubles at double 20 then that segemnt to decrease by itself to 33% without changing the size or position of the others. This would apply to all dartboard segments. This might help the player see which areas of the board they are strongest at doubles not just which doubles.

    Is this possible? Radar graph (hate them) any better?

    Many Thanks as ever
    Paul
    Attached Files Attached Files
    Last edited by pdauction; 06-05-2014 at 02:05 PM.

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

    Re: Static individual pie chart areas

    This uses a dount to shade the doubles section by accuracy.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-07-2009
    Location
    Lytham, England
    MS-Off Ver
    Excel 2003+07
    Posts
    75

    Re: Static individual pie chart areas

    that's spot on Andy, thanks for that.

+ 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. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  2. Selecting Chart Areas
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2011, 08:13 PM
  3. How to collor certain areas of a chart
    By Piemonte in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-26-2007, 01:24 PM
  4. [SOLVED] How do I set my Excel Chart to not show areas where I have no dat.
    By AmyJ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-14-2005, 06:06 PM
  5. highlight areas of chart?
    By Stan Altshuller in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-14-2005, 06:06 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