+ Reply to Thread
Results 1 to 4 of 4

Changing the fill color of a portion of a pie chart based on a cell value

  1. 12-28-2016, 12:26 PM #1
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Changing the fill color of a portion of a pie chart based on a cell value

    There will be two parts to a pie chart. I am only interested in one side of it but i would like that side to fill color based on the value of a cell..... im going from bright red to bright green. perhaps make it in 10 steps???

    If anyone has done something like this i would be very appreciate.

    Thank you,
    K
    Reply With QuoteRegister To Reply
  2. 12-28-2016, 12:53 PM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Changing the fill color of a portion of a pie chart based on a cell value

    Hi,

    Some more information would be useful here but I believe you could do it by plotting 10 slices of different colours originally and then having each slice only visible if the value in the cell is a particular one- so you only ever have two slices actually visible.
    Attached Files Attached Files
    Last edited by xlnitwit; 12-28-2016 at 01:03 PM.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 12-28-2016, 01:00 PM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Changing the fill color of a portion of a pie chart based on a cell value

    Hi,
    Have a look here: http://datapigtechnologies.com/blog/...-source-cells/ Is it enough for you?
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  4. 12-29-2016, 11:20 AM #4
    sungen99
    sungen99 is offline
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: Changing the fill color of a portion of a pie chart based on a cell value

    Thanks guys....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to fill color cells based on another cell's fill color?
    By putritersenyum in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2016, 08:58 AM
  2. [SOLVED] Gantt Chart - Changing cell color based on % completed
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2014, 06:40 PM
  3. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  4. [SOLVED] Changing fill color of shapes based on changing cell value
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2012, 10:33 AM
  5. Changing Cell Fill Color On Select
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2011, 07:06 PM
  6. Color Fill Regions on Chart Based On Value?
    By zackpasi in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 06-18-2009, 10:42 AM
  7. Changing chart color based on number entered
    By confused chart girl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1