Conditional formatting on charts

[TMervis]

I have a bar chart of daily sales. I want each day to be color coded according to the number of sales made that day, for example - 0-20 sales = Red, 21-40 sales = Orange, 41 - 60 sales = Yellow, 61+ sales = Green. Lets say on Monday, 35 sales were made, that bar should be colored orange. Is this possible? thanks

 

[pgc01]

Hi

Check here the Conditional Formatted Bar Chart section in this article from Jon Peltier:

https://peltiertech.com/conditional-formatting-of-excel-charts/