+ Reply to Thread
Results 1 to 9 of 9

Bar chart conditional formatting based on x-axis value

  1. #1
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    154

    Bar chart conditional formatting based on x-axis value

    Hi all,

    I need to create a conditionally formatted bar chart based on the value of x-axis

    This is a rating survey question and I wanted to conditionally format low ratings, medium ratings and high ratings
    So in this case, any bars below 3 on x-axis will be red and any bars greater than 3 on the x-axis will be green
    Rate pic.jpg

    I appreciate your help
    Attached Files Attached Files
    Last edited by mq1973; 04-09-2021 at 11:43 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,289

    Re: Bar chart conditional formatting based on x-axis value

    This kind of technique (https://peltiertech.com/conditional-...-excel-charts/ ) is usually the first one recommended. Note that most of the work is in the spreadsheet. The specific example he demonstrates the technique with shows conditional formatting based on Y value, but there's not reason you could not do the same thing based on X values or something else.

    Give that a try and let us know where you get stuck.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    154

    Re: Bar chart conditional formatting based on x-axis value

    Hi MrShorty,

    Thank you for the quick response. I tried to modify it so it does the conditional formatting based on x axis but I am unable to do that.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,081

    Re: Bar chart conditional formatting based on x-axis value

    Can you show what you tried in your updated example workbook?
    Attached Files Attached Files
    Last edited by jeffreybrown; 04-09-2021 at 01:23 PM.
    HTH
    Regards, Jeff

  5. #5
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    154

    Re: Bar chart conditional formatting based on x-axis value

    Quote Originally Posted by jeffreybrown View Post
    Can you show what you tried in your updated example workbook?
    Sure, please see attached
    Attached Files Attached Files

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,081

    Re: Bar chart conditional formatting based on x-axis value

    Take a look at post #4. I've updated it with an attachment.

  7. #7
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    154

    Re: Bar chart conditional formatting based on x-axis value

    Quote Originally Posted by jeffreybrown View Post
    Take a look at post #4. I've updated it with an attachment.
    Thanks so much jeffreybrown. This is exactly what I was looking for.

    I really appreciate it.

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,081

    Re: Bar chart conditional formatting based on x-axis value

    You are very welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  9. #9
    Forum Contributor
    Join Date
    04-26-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    154

    Re: Bar chart conditional formatting based on x-axis value

    Of course, I will mark the thread as completed and add reputation
    Thanks again jeffreybrown.

+ 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: 0
    Last Post: 06-18-2019, 12:14 PM
  2. Conditional Formatting Data Bar Axis
    By ptrling in forum Excel General
    Replies: 6
    Last Post: 12-16-2014, 10:53 AM
  3. Replies: 12
    Last Post: 04-08-2014, 08:12 PM
  4. Conditional formatting Chart Axis number type
    By Dial1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-09-2013, 07:11 AM
  5. Conditional Formatting - Change Text to CHAR(252) Automatically
    By nkitchen31 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2013, 10:06 PM
  6. Conditional Formatting of Numbers on Axis
    By JungleJme in forum Excel General
    Replies: 3
    Last Post: 09-14-2012, 09:21 AM
  7. Conditional Formatting of Axis
    By winshent in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-25-2009, 10:28 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