+ Reply to Thread
Results 1 to 2 of 2

Format chart background color based on value

  1. #1
    Registered User
    Join Date
    12-06-2010
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Format chart background color based on value

    Hello,

    Happy Friday folks! Got a question here, search all over the place but couldn't find any information. Youtube doesn't have it at all.

    Here you go...I need to apply the green, yellow and red color to the chart background. The Y Axis, I have 0 to 110%. So, 0-80% set to Green area, 81 - 90% set to yellow and 91 - 110% set to red. This is a simple stacked column bar chart.

    Please help. Thank you.!

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,594

    Re: Format chart background color based on value

    Hi there,

    I haven't checked this out in detail, but it might get you moving in the right direction:


    Hope this helps.

    Regards,

    Greg M

+ 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. change background textbox color based on text color in cell
    By atadaliran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2021, 05:34 AM
  2. Change color of column chart based on conditional format
    By dondada82 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2017, 10:01 PM
  3. Count / Sum based on Background Color with Manual and Conditional Format Color
    By sam99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2014, 08:00 PM
  4. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  5. Replies: 2
    Last Post: 02-25-2013, 03:36 AM
  6. Set Background Color based on Conditional Format
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2012, 06:30 PM
  7. Replies: 4
    Last Post: 09-15-2012, 02:46 PM

Tags for this Thread

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