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

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.

Can you show what you tried in your updated example workbook?

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

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.