Support Board
Date/Time: Sat, 28 Dec 2024 08:31:59 +0000
Post From: Color Bar
| [2016-04-14 10:26:42] |
| User38606 - Posts: 108 |
|
Hi, I am using Spreadsheet Study / Alert. I have developed a study whereby I want certain bars to be coloured into 2 different colours. The study populates two columns with either TRUE or space. This is formula driven result. I have chosen columns P and O to be populated with either TRUE or space. When Column P has TRUE, then colour the bar Blue. when Column O has True then colour the bar Red. Have followed all steps of choosing Colour Bar/ in Draw Style in Subgraph and choosing right colours. but bars do not get coloured. I noticed that if I type in TRUE & it is text...then bars get coloured. but if True is not typed in manually, but is formula driven...no colouring. I also wrote up a formula to convert formula driven TRUE into =text(CELL A,""), CELL A is formula driven TRUE, otherwise converting into text ....still no recognition. Can you advise where I am wrong? |