# Bar Chart, Conditional Color

**URL:** <https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233>\
**Category:** Ignition\
**Created:** [July 16, 2015, 5:14pm UTC](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233 "2015-07-16T17:14:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bfearnow](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfearnow/32/3337_2.png) [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\
**Post date:** [July 16, 2015, 5:14pm UTC](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233/1 "2015-07-16T17:14:54Z")

</div>

This is probably a stupid question, but is it possible in a bar chart to have the color of each individual entry change based on its value?

For example anything over 85 is green and anything under 85 is red?

Thanks in adavance.

---

<div class="post-metadata">

**Author:** ![bfearnow](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfearnow/32/3337_2.png) [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\
**Post date:** [July 16, 2015, 5:40pm UTC](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233/2 "2015-07-16T17:40:20Z")

</div>

Okay I did this a strange way. It works though.

FWIW I made two data sets

SELECT Hour,  
IF(Efficiency \< 85,Efficiency,0)  
AS Actual  
FROM shopfloormonitordata WHERE Machine = ‘T5’

SELECT Hour,  
IF(Efficiency \>= 85,Efficiency,0)  
AS Actual  
FROM shopfloormonitordata WHERE Machine = ‘T5’

Thanks!

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [July 16, 2015, 5:55pm UTC](https://forum.inductiveautomation.com/t/bar-chart-conditional-color/10233/3 "2015-07-16T17:55:08Z")

</div>

Not bad! ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

It should be possible to do it in one dataset:

```auto
SELECT Hour,
IF(Efficiency < 85,Efficiency,0) AS Actual1
IF(Efficiency >= 85,Efficiency,0) AS Actual2
FROM shopfloormonitordata WHERE Machine = 'T5'
```

Not tested, but it should work.